Search results

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

I tried to recreate your db and i didn't have that problem, check if you have it. If you dont have problems with this db, upload your db if you can, or post your code and table information.

You mean scroll down when using the mouse wheel to change to another customer record?

Hi, from what i understand is that you cant go back to the main form, is that the problem?

try on your Form_Load event Me.Filter = "MainID = 1" Me.FilterOn = True

Take your table invoice details (tblDetails) and add an extra field fldDetailsID - AutoNumber Create a query (qryDetails) Select * From tblDetails Order By fldDetailsID Then Bound your form to qryDetails this will work for the invoices you will create from now on

Is your subform bounded to a table? if so, is the table ordered by the item name? If this is the case check in the table's Order by property and erase whatever text is there. If this doesnt work create a autonumber field, then create a query including the fields in the table and ordered by that...

You cant bound either an update or append query because it doesn't return any records to see. It just performs the action of update or append the record u wanted to. That is why you can only use Select queries to bound to a form. I think when they said you should built from query they meant...

In main form's module use your subform Enter event: Private Sub sfmSubForm_Enter() DoCmd.GoToRecord , , acNewRec End Sub

The only way i can think of is using forms with vba code Do you know how to make forms and use vba code with them?

I undestand now, maybe by mistake you have somewhere in your code to set warnings false but not to set it back to true. In your immediate window run: Docmd.SetWarnings True

Play with the BeforeUpdate event. Here is an example: Private Sub Form_BeforeUpdate(Cancel As Integer) Select Case MsgBox("Would you like to save changes?", vbYesNo) Case vbNo Me.Undo End Select End Sub

You mean: If a new user registers then create a website record?

Yeah you are right but i was thinking, maybe if i check if the ldb files exists then close instance. With the fileSystem Object with FileExists function, maybe will save me all of that code. EDIT: Bad Idea it creates it before running the first stack of code ill use what bytemyzer's link says...

Im sorry for not being specific, The BE is on the Server and each user in their workstation computers (local computer) has its own FE. What i want to do is to stop the user from having more than one instance of the same MDE File in their own computer so when he tries to open the same MDE file...

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

What i am trying to accomplish in a continuous form is "if a combo box is NOT dropped down, then when using the down arrow key (Form's KeyDown event) go to next record, else do what it does by default (which is to go down thru the combobox list)" Any IdeaS?

Try to change the "subtype" combobox rowsource to: SELECT submaterial FROM subtype WHERE material = forms!YourFormName!YourComboboxname And whats the structure of ur tables?

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

Try if the value is < than 0