Search results

SP 3 and I have run windows update - I have access 2007 and office 2003 on the same Vista machine. Could that be the problem do you think?

Hi, I have a FE and BE database that I developed in Access 2003 in an XP OS. It all worked fine before on the XP machine, but now I have vista and I am finding it difficult to run it although I've installed office 2003. The error I am getting is as follows: Object or class doesn't support the...

I get this compile error 'Method or Data Member not found' on the following line: me.controlname.rowsource = strSQL What do you mean by control name? Is that the form name? The parameter I need to pass is for the form, so I replaced controlname with the name of my form. I also took the Me...

That's brilliant, but will not work for me as I need to pass the value of a variable automatically to the query.

Hi DCrake I have tried your second approach with a similar example, but I am getting the error that dbs is not defined. Is that a reserved word? Or is supposed to be something that I am not obviously getting? Thanks, B

Hi I have created a simple query that is used as the record source of one of my forms. I want to pass the query a different criterion each time the form is opened. Any suggestion/example on who to do that will be very much appreciated. Thanks, B

Will try that - thanks Jibbadiah. I don't understand what you mean Rabbie. Can you elaborate please?

Hi folks, I've a BE/FE database where the BE is on the server and the FE on different PCs. I have got linked tables in my FE and the connection between them and the BE is correct; however, users cannot view data entered by others. They can only view data entered by themselves!! I'm not sure...

Hi folks Is there a linked table manager in access 2007? Cheers, B

Good Tutorial BobLarson.

Found it! Thanks.

That's excellent. I locked my self out try to basically disable form design option when you right click on forms. Do you know how to do that please?

Hi Is there anyway of returning the menus that I removed from the Tools > Startup options back? It looks like I have locked myself out of my FE!!!! Thanks, B

That's brilliant. Thanks very much.

Hi, I wrote the code below in a module. The text box that this part of the code is getting its value from has a DLookup in its control source. The problem is that when the DLookup does not match the criteria it looks for, it returns Null. The code tries to assign Null to a variable of type...

Haha, that's true. It's been a while between me and school projects! I did write urgent beause I was quite desperate to know the answers as I was writing a user manual and did not find anything exactly about that in Google! The DB is installed in the client's site now, so no more urgency and...

That's great information. Cheers. I am more interested in the Backup in this case so I will go for that.

That's excellent! Thanks Garry.

Hi folks I wonder if you can help with these two questions please? To compact and repair a FE, does each client have to be logged off or doesn't it matter? What's the difference between make database replica and make database backup in access? Thanks a lot, B

Are your FEs copies or shortcuts to one FE on a share folder in your servers? You should not make shortcuts of the FE that point to one copy of the FE on the server which itself points at the BE. Make sure all of your FE copies are pointing at the BE directly.