Search results

Hello access gods, I have successfully implemented the code to prevent multiple instances from this article found in this forums : http://www.mvps.org/access/api/api0041.htm Now, can someone please enlighten my path on how to automatically focus on the original instance after preventing the...

Hi, i have never really understood the main difference between those three. I've been always using recordset, i would like to know: When should i use the other two?

From access help: Function RepairDatabase(strSource As String, _ strDestination As String) As Boolean ' Input values: the paths and file names of ' the source and destination files. ' Trap for errors. On Error GoTo error_handler ' Compact and repair the...

I wanted to let the user choose which jobs he wanted on his reports and save the selection for the future so i created a new table . tblJobView - JobID as FK - View as yes/no field It works fine (the report shows the jobs selected only), the only downside is it shows null state checkboxes (as...

Is there a way to stop users from opening the front end file twice (stop from having two sessions of the same FE at the same time)? I've been searching the forum and found this http://www.access-programmers.co.uk/forums/archive/index.php/t-67724.html but since im not using an .exe updater is...

Is there a way to test or know if a combo box is dropped down?

Well the title pretty much the tittle says what happens. The users using access 2007 will get this "Enter Parameter Value" inputbox, but the 2003 users donut. I know that when you get an "Enter Parameter Value" is a problem in the record source of ur forms or subforms which i couldn't find...

I have several number type fields which i would like them to be equal to 0 each time the user erases (uses BackSpace) to clear it. What im doing is the following: Private Sub txtBurden_AfterUpdate() If IsNull(txtBurden) Then txtBurden = 0 End If End Sub My issue here is that i have to do...

I have this on forms keydown event: Select Case KeyCode Case vbKeyDown ' Go to next record End Select But when a combo box has the focus and the user just wants to dropdown it using Alt+DownArrow . It will take him to the next record. And when he wants to go tru the combo box options using...

Hi, I have a well normalized data base with a table with 20 Fields. Since on my queries i will be using most of the time just 5 fields of it, should i split my table into two 1 to 1 tables? since I've never done this, which will be the best way to do so?

Hi, im having trouble with the design of a Inspections Log (building permits) data base: so ok, Each City (tblCity) can have many Jobs Each Job (tblJob) can have many Permits Each Permit (tblPermit) can have many Inspections (tblInspections) a Inspection has a InspectionType (ie: Partial...

Hello, i have an access db on my office network and i would like to show some querys (Read Only) online using an access connection with ASP. It doesn't need to be real time, just updated once a day. So i was thinking of somehow update the back end of the db in the web server some time after...

Hey all, i just would like to know if there is a way to have a fixed number of records in a query. Let's say, example (a), a query returns 2 records (qry1); i would like to have my query (qry2) to have 5 records, so the first two records will appear and then 3 blank records. (b) A query (qry1)...