MYSQL Data Entry Form

Justin Bennett Justin.Bennett at dynabrade.com
Mon Jul 25 15:44:46 EDT 2005


The access looks like it might do what I need, The webmin module seems 
to be working ok, though this table might have like 60 columns, so once 
I get the database created we can see how it looks in webmin. might be 
easier to manage in access


Justin Bennett
Network Administrator
Dynabrade, Inc.
8989 Sheridan Dr.
Clarence, NY 14031
 



On 7/25/2005 3:32 PM, Richard Hubbard wrote:

>For things like Data Entry, you can always have  MS
>Access link to MySQL tables. Then you hand the users
>the MS Access MDB file and (provided you are pointing
>to a machine they can get to) they can access the
>files.
>
>With not much work you can also set up a custom
>program in (gasp...arrgh...cough) Visual Basic.  The
>Data Form wizard is almost painless.  (If you need any
>extra work, though VB is a nightmare to code in).
>
>
>--- Justin Bennett <Justin.Bennett at dynabrade.com>
>wrote:
>
>  
>
>>Ok, Thanks for the info. Gives me a good route to
>>go, I'm compiling 
>>MYSQL now, I want to see if the webmin module is
>>decent for it, if not I 
>>may go the access route.
>>
>>Justin Bennett
>>Network Administrator
>>Dynabrade, Inc.
>>8989 Sheridan Dr.
>>Clarence, NY 14031
>> 
>>
>>
>>
>>On 7/25/2005 3:16 PM, Mike Richardson wrote:
>>
>>    
>>
>>>Justin Bennett wrote:
>>>
>>>      
>>>
>>>>Thanks, I hope it doesn't come to that, not a big
>>>>        
>>>>
>>odbc fan.. Seems 
>>    
>>
>>>>flaky every time i've used it.
>>>>
>>>>But thanks for the tip.
>>>>        
>>>>
>>>Just to ease your mind:
>>>
>>>We've been using the MySQL odbc connector for
>>>      
>>>
>>about 2 1/2 years with 
>>    
>>
>>>no noticable incidents.
>>>
>>>      
>>>
>>>>On 7/25/2005 2:54 PM, Mike Richardson wrote:
>>>>
>>>>        
>>>>
>>>>>Justin Bennett wrote:
>>>>>
>>>>>          
>>>>>
>>>>>>I'm looking to deploy a mysql database for web
>>>>>>            
>>>>>>
>>work via PHP (our 
>>    
>>
>>>>>>stuff has been oracle so far).
>>>>>>
>>>>>>What I'm looking for is an easy way a windows
>>>>>>            
>>>>>>
>>user could update, 
>>    
>>
>>>>>>delete, insert, data into the database. I'm not
>>>>>>            
>>>>>>
>>looking to make the 
>>    
>>
>>>>>>user upload a csv or anything like that to
>>>>>>            
>>>>>>
>>update records.
>>    
>>
>>>>>>A nice GUI data entry form would be nice. I
>>>>>>            
>>>>>>
>>could always write one 
>>    
>>
>>>>>>in PHP but was hoping for something canned,
>>>>>>            
>>>>>>
>>maybe with a wizard so 
>>    
>>
>>>>>>I could create more forms in the future. It
>>>>>>            
>>>>>>
>>doesn't need to be web 
>>    
>>
>>>>>>based, it can run on w32, and it doesn't have
>>>>>>            
>>>>>>
>>to be free.
>>    
>>
>>>>>
>>>>>
>>>>>Although it's not necessarially being developed
>>>>>          
>>>>>
>>(or even supported) 
>>    
>>
>>>>>anymore, MySQL Control Center has always been a
>>>>>          
>>>>>
>>good data 
>>    
>>
>>>>>manipulation tool. It may be a little confusing
>>>>>          
>>>>>
>>for the general 
>>    
>>
>>>>>user, though.
>>>>>
>>>>>Otherwise, if your clients have MS Access
>>>>>          
>>>>>
>>installed, you can install 
>>    
>>
>>>>>the  MySQL ODBC connector on Windows. In Access,
>>>>>          
>>>>>
>>you can link tables 
>>    
>>
>>>>>up to the MySQL db and let them edit data there.
>>>>>
>>>>>Both of these pieces of software are available
>>>>>          
>>>>>
>>of MySQL's Developer 
>>    
>>
>>>>>site. http://dev.mysql.com/downloads/
>>>>>
>>>>>*shutters* I just promoted an MS product for
>>>>>          
>>>>>
>>getting things done...
>>    
>>
>>>>>          
>>>>>
>>>>        
>>>>
>>>      
>>>
>
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around 
>http://mail.yahoo.com 
>  
>



More information about the nflug mailing list