Search results

I'm running into a bit of a problem when trying to open a recordset for a query. What I've got is a query referring to all fields in a single table with two filter criteria producing a single record from the tables data. The code I'm using is as follows: Set My_DataBase = CurrentDb Set...

Cheers for that all seems to be working ok. I do though fail to see what use the on click event is. Hay Ho there you go. D

Would someone be able to help with a tab control problem I've got? I'm currently using a form with two pages on a TAB Control, and need to trap the event when either Page-1 or Page-2 tab in clicked with a mouse. Alas I'm only able to generate a click event if I click the area to the right of...

Cheers for that, the ".Text" syntax seems to get over the problem. Simple if you know how, but why is Access so quirky? Cheers again anyway. D

This is a follow on from a thread posted last week called 'Control focus following "Enter" key press'. I've got a control called Text_Box1 that I wish to keep the focus on once a number has been entered and the 'Enter' key has been pressed. If I use the follow code the focus stays with the...

Cheers muckers, I'll try the KeyCode method it's given me an idea. In answer to your question as to what I'm trying to do, I've got a text box that is used to enter a part number about which various data is retrieved, but what people here tend to do is keep tapping part numbers into the text...

Cheers, but I'm affraid I've tried that already and it doesn't work. It just inserts a carriage return into the text being entered into the box. D

Would anyone be able to help with focus flow? I've got a text box (Me.Text_PartNumber) which I'm trying to get the focus to stay with once the enter key has been pressed instead of moving to the next control in the tab index list. Under the options menu I've set the move after enter option to...

Sorry punters, I've got a laptop with a remote usb keyboard which has been chucking the occassional "odd" key stroke all day and has just locked up altogether. One re-boot and all seems to be working fine, including the vbKeyCode constants. Guess I need a new key board. Sorry muckers D

I'm having a spot of bother getting my head round trapping which key has been pressed when using the KeyDown event. I'm looking for when the left arrow key is pressed so I can move the cursor to the end of the text in an text box. I've looked up the KeyCodes list in the help screen under...

Cheers for that I've got the list I needed now.

Does anyone out there have any ideas on how I can get a full list of the error codes and their descriptions for microsoft access? I've set up a simple table with two fields, one for the error code and the other for the description. I've written a short bit of code (see below) to build the table...

Not yet, but I've just been told to try running the install with my anit-virus switched off. I'll give this a go later this evening and let you know. Cheers D

Cheers for that I'll give it a read and try installing again D

I've just run an install with the log running and the log tells me "Installation Operation Failed" I haven't looked at permissions or anything else yet, but am running out of time for today. Any reason on the face of it why the installation would fail? My machine looks as though it meets the...

The full syntax I used is: setup sapwd="GaelicFatboy" instancename="SQL_Reynard" targetdir="c:\My_SQLServer\" Cheers D

I'm running out of possible options to install and run MSDE server on my laptop machine so I that can start building 'Project Applications'. I've down loaded the MSDE2000A application from the internet (no version of MSDE available on CD rom, I purchased Access separatley), and ran the...

I've just started down the rocky road of stepping up to using Access Projects and installing MSDE as my server. However, I'm having some trouble in getting up and running. In short I cannot find the MSDE server in order to start it running. I've installed the MSDE server on my laptop for now...

I'm looking at creating a project database for the first time and I'm looking for a little background if anyone can help. If I install the MSDE on my standalone laptop can I write and develop the database on the laptop without being connected to a server and then transfer the files once I'm...

I've got a database with forms originaly designed using Access 2000. I've converted the files to 2003 format using the tools menu, but the look and the layout of all the controls are as the 2000 format and not the newer looking 2003 format. Is it possible to convert these 2000 style forms to...