Search results

I'm not really sure if this is the right place to post this but i've just found a major problem with database and am leaving today so it's kinda urgent! I have two linked tables in my database that are linked to and ODBC database. In Access 2003 when i update my tables using the linked table...

the form is literally just a switchboard with buttons to navigate around the database. This shouldn't be too much of a problem should it?

also if this hides the button where do i need to put the code in order for it to work? the form it is on is always open. thanks!

will i need to repeat the two lines of if statement for each user i want to be able to use the button?

Is there a way in which to assign user permissions to vba code? I have some command buttons which run vba code but i only want to allow certain users to use these.

Grrrr, this worked yesterday but today it says it expects a variable or procedure not a module

Is that all the wizard does?!

Sadly still no luck :(

Thank you anyway, you've been really helpful! Am Currently trawling through all of the past posts hoping for some clues!

nothing noticable (i.e. error messages) happens but the menu option is greyed out until i change something. I assume this means there are no errors?

what should happen when i click on that? Sorry can you tell i'm not really a computer person!

How would I try and do that?

I am trying to split my database but when i run the database splitter it comes up with the following error messages: Subscript out of range And Invalid procedure call or arguement Does anyone have any ideas what could be causing these or how to fix it? Thanks

Fantastic! Thank you :)

Not quite sure where I am supposed to put that! My VBA knowledge is very basic! I currently have: Private Sub Command25_Click() On Error GoTo Err_Command25_Click Dim stAppName As String stAppName = "excel.exe E:\Common files\Database\non" Call Shell(stAppName, 1)...

I am trying to get VBA to open an excel spreadsheet. It is perfectly happy when I use a file with a pathname that doesn't contain any spaces but when i try and open a file from e:\common files it won't work. I'm sure this is really simple but I just can't work out how to make it open! Thanks