Recent content by rob1234

They changed names to mdbmakers.com. Something to do with trademark regulations on the name accessvba.

It should work. I use notepad for all my web based programming (mostly asp and html). I've heard wordpad can screw things up though. You might want to check that the file is saving as xxxx.php and not xxxx.php.txt (I think php files are .php right?). Windows might hide the .txt part if you...

Try this http://www.filemaker.com/downloads/pdf/fm_access_comparison.pdf. I've been hired to move a big filemaker db to access because everyone here hates filemaker. Although, they're using version 5.5 and it's up to version 8 so it might be a little better now. Check out www.fmforums.com too.

Thanks, got it now.

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...

Is there a way to lock only certain records directly in a table or through a form. I've just been tasked with verifying the data in a db and I'm supposed to lock a record once it has been verified so no one else can edit it. I supposed I could move the record to new table once it's been verified...

Are you asking me for help or is your name Rob too. Anyway, if you are I've just started using access a month ago and haven't even looked at combo boxes yet but couldn't you just do something in the getControlValue function like if (name of control passed to function = name of combobox) then...

Alright, I solved it by creating a recordsetclone in the form_current and then creating a function getControlValue in the form class that would take the name of the control and return the value from the recordsetclone (this only worked if the controls had the same names as the fields in the...

I'm getting the same error as FNQChick on a form based on a query that includes two tables in a one to many relationship which I assume is cause by this http://support.microsoft.com/default.aspx?scid=kb;EN-US;207836. Is there a way to get which changes were made without using ctl.oldvalue?

Used Me.RecordSet.Move

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...

OK, I found the tools->startup thing. Is there anything else I should be considering.

Can I prevent users from entering design view in the front end as well

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...

That's what I thought. I just got off the phone with him. Apparently, he hasn't really worked with Access before. He just knows people that have had problems with programs they have written that interact with Access db's when converting between versions. He meant that the programs would have to...