Search results

I'm sure this has been answered but I can't think of the right keyword to search for. I'm transferring data between tables inorder to normalize an old db and basically I have a docmd.runsql("insert into .... values (... ' " & rs.fields("fieldname") & " ' ... but a lot of the records in...

I have a form for viewing and editing all the records in a table and a button that when clicked lets you select an excel file and import it to the table. This all works fine except when the import is finished I want the current record displayed on the form to change to the first record imported...

I split my database so that users could only edit/view data through the forms but when I opened the front end the tables where still there (linked though) and I could edit and look at them. I assume this is normal so how can I prevent users from seeing the tables. Do I just set them to hidden...

I've been hired to clean up and convert a flat filemaker database into access 2003 and I've spent the last two weeks learning the ins and outs of access and doing preparations. Well, today some high up database guy in another department told me not to use access because in the future when a new...

I'm writing a VBA function that removes any extra whitespace from text fields and I want to pass to that function the name of the field in a string. The problem I'm having is I have a recordset 'rsUpdate' and a string 'field' containing the field name and I want to do something like...

I have a table in a healthcare patient database that stores Admitting Number, Scan Number, Last Name, and some other fields detailing the scan. Each patient can have multiple scans and I'm trying to design a query that lists how many scans each patient has had by finding all the duplicate...

I'm redoing a patient info database for a healthcare facility (right now it's a flat Filemaker db with 869 fields and 4000 records) and I had pretty much decided to move it over to access but I was talking to one of the database guys at the local University and he mentioned that if there is...