Search results

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

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

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

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

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

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

Hi Has anyone ever got this error message before? I’ve never came across it and I don’t know how to fix it. The error message displayed when I added three extra labels to a form then tried running it. At the beginning, it took more time than usual to think about it then the error message was...

Hi I am trying to write simple code that undoes entering a new record and moves the focus to a mandatory field. I wrote the code below; however, I get this run time error message each time I run it. DB can't move the focus to the control PlotNum. My code: Private Sub...

Hi, I want to connect a DELL INSPIRON 5150 Laptop to my Philips 42PFL5522D/05LCD screen TV. I bought a cable that has an HDMI in one end and a DVI on the other end. Then, I used an adapter to adapt DVI to VGA because my computer has VGA socket. Then I used Audio L/A cable exactly as shown on...

Hi I have created a next button that goes to the next record each time the user presses it. however when records finish, it tries to create a new record. Is there anyway to stop it once it reaches the last record. I don't want it used to create new records. Any suggestions will be very much...

Hi Any one knows how to trap access messages that don't display an error number such as the delete error: Relationships that specify cascading deletes are about to cause 1 recod(s) in this table and in related tables to be deleted. The message above does not display a number and when I...

Hi, I want to requery a form from time to time; however, when that happens I want to return the record that was displayed at the time before the requerying. Now when I requery, it goes back to the first record. Any suggestions will be very much appreciated. Thanks, B

Hi I wrote code that should validate a field when entering a new record and then if a condition is true, that new record should be cancelled and not entered into the table. I managed to partially achieve this by writing the code below, but the new record does not get cancelled because the...

Hi, I have searched on this forum about a solution to this and found out that 3 part compound keys are unwise although they are legal. Now, I am not sure how to design this database! Basically, I need to store information about site (a big part of land), phase (a portion of site) and Plot (a...

Hi, I have a table that stores default information called 'dat HouseType'. The information on this table appears on a form depending on the value users select from a combobox on another form; however, there will be situations where users need to change some of the fields for certain records in...

Hi I have searched for this in the forum search, but nothing related came up. I am wanting to make a combo that will allow data entry as well as display the normal drop down list for viewing data. Is that possible in the combo control in Access? Any suggestions will be very much appreciated...

Hi, I wonder if anyone can help with this please. I don't know if it's possible in Access: I want to create a form that Reads from one table, but Writes to a different table. Any examples, suggestions will be very much appreciated. Thanks, B

Hi folks, I have searched on this, but did not find any article that is comprehensive enough. I wonder if anyone can advise on database maintenance routines particularly for Microsoft Access. I know: Regular Back ups Compact and repair database Please fell free to add on to this list...

Hi, I have tried to Requery a subform of a subform, but I can't get it to work. I tried this: Me.SubForm1.Form.SubForm2.requery Also: Me.SubForm1.SubForm2.requery And: Forms![SubForm1]![SubForm2].Form.Requery Any help will be very much appreciated. B