Search results

Check if there's a form with same source as your SQL query that has Record Locks property set to All or Edited. That will lock your table exclusively to that form. Helped me when I experienced a similar problem ... ;)

The vars are actually strings ... Here is an example of one of the fields in the query that I tried adding Nz([table].[field]) the replacement arg is optional but I made it "00" not to ruin anything for the left() and right() functions. The query: FormatMins((SELECT DISTINCTROW...

Hi everyone, I am using this code to hide Access when my DB is running. Forms are set to Modal + PopUp, and then it works. However, Access is also hidden from the Process bar in the buttom of my screen so I cannot switch between running apps unless I use ALT+TAB. Is there a way to modify the...

Still no joy ... var = Nz(var) Should return 0 if var is Null ... Still I get #Error

Hi all! I have a query that returns some fields with "#Error" ... The reason is that I call a function in the query, and the function chokes if there are no matches in my query criteria and therefore no argument is sent to the function. I tried putting this in the function: var =...

Is there a way to see my total edit time for my project, like I can see edit time in a Word doc? (File -> Properties) Thanks all :)

It is a multi user, but a user will only be able to change records linked to their own username - so in that respect it is kind of single user ... Btw, is there a way to set all forms with the property no locks in one go?

Tried changing record locks to: None Now it works!!! :D :D :D Been battling this for 3 days ... Thanks RG! (What probs will I potentially run into with no locks?)

Record locks: All records. What does the record lock property do exactly?

I have a couple of forms with the same source - or rather sources are different queries accessing the same table. Both forms have edits allowed. My problem is that when I have had one of the forms open, the second form cannot get its data when I load it ... Even if I do a: DoCmd.Close acForm...

Brilliant! Thanks grim squeaker :D

This is in the form load event for frmDetails. Liste26 should show the total of buys for the customer ... Private Sub Form_Load() Dim SQL As String SQL = "SELECT DISTINCTROW Sum(buys.pris) AS [Sum Of pris] FROM buys GROUP BY buys.kunde_id HAVING (((buys.kunde_id)='" SQL = SQL & Me.OpenArgs &...

Does anyone have a sample of a db with a report that will print the records 3 across and 8 down to an A4 sheet of labels (24 per page)... I have absolutely no clues ... :confused:

When I view customer details in the attached db, the list (liste26 on frmDetails - lower left on the form) doesn't get data. The SQL syntax should be correct since I got it from a qry made with the wizard. Whats wrong???? I'm sure there's a simple explanation ... :rolleyes:

Tried changing the . to ! and "Form_frmIndex.Requery" to "Form_frmSubformFA![SubFA].Form.Requery". When I hit "Save" and "Edit" a couple of times on the FA log tab I get an error in the "Edit" department: It says that the object doesn't exist or was deleted and the highlights...

Okay, WindSailor - will give it a try :) In the mean time here is the DB that causes grey hairs along with an example that works ... Try going to the FA Log tab and hit the Edit/Save/Add new labels a couple of times ... http://www.iamsteff.com/logbook.zip http://www.iamsteff.com/Example.zip...

Have tried requery on: Main form Sub form Tab ctl Subform window on Tab ctl Still no luck :(

Since I have a lot of forms open at the same time on different tabs, and some hanging in thin blue air (being open, but not to display) I just wanted to be sure that the code knew where to go ... :o -plus I find it easier for reading when debugging ... (in the maze of main form, subforms and...

Thanks RG! The code looks better with a Case structure, but problem persists. I narrowed it down to this: 1) I click "Edit" and the subform correctly changes to "frmFALogEdit" 2) I click "Save" and the subform correctly changes back to "frmFALog" 3) I click "Edit" again but the subform now...

I am using some labels as controls on a form: Private Sub Label1_Click() If Form_frmSubformFA.Label1.Caption = "Edit" And Form_frmSubformFA![SubFA].SourceObject = "frmFALog" Then Form_frmSubformFA![SubFA].SourceObject = "frmFALogEdit" Form_frmSubformFA.Label1.Caption = "Save"...