Recent content by hockeyfan21

Thanks Mark - I did check that but forgot to mention in my first post. It is definitely set to "Increment". Regards, Toni

I have a temp table with an Autonumber PK field "EntryID" set to "no duplicates". The database is split with users having their own copy of the frontend on their desktops and the temp table is stored in a single backend. Can anyone tell me why it is jumping numbers so drastically when users...

Hi, I need to add an additional filter to my unbound form and can't seem to get the syntax right - I have a text field in my form "[B Style]" that has either a "Y" or "N" I want to add a checkbox on my main form where, if checkbox=True then [B Style]="Y" Private Sub ckBStyle_Click() Dim...

Think I've figured it out - decided to go another route and put them all in one string If IsNull(cboDiv) And IsNull(cboGender) Then stLinkCriteria = "([Category]= '" & Me.cboByCategory & "' OR [ProdtSubCatLongDesc]='" & Me.cboByCategory & "') AND ([Approved]=FALSE AND [Denied]=FALSE) " Thanks...

Thanks, I changed the parenthesis but then just realized that it now requires a selection in every combo box, otherwise I end up with a trailing 'AND' ([Category]= '2000 - RUNNING' OR [ProdtSubCatLongDesc]='2000 - RUNNING') AND If IsNull(cboDiv) And IsNull(cboGender) Then stLinkCriteria =...

Genius!!! Thank you, all working great now. If IsNull(cboDiv) And IsNull(cboGender) Then stLinkCriteria = "([Category]= '" & Me.cboByCategory & "' OR [ProdtSubCatLongDesc]='" & Me.cboByCategory & "')" stLinkCriteria2 = "([Approved] = FALSE)" & " AND ([Denied]=FALSE)" stLinkCriteria3 =...

Not quite sure I understand but here's what I tried - still showing items where Approved = TRUE If IsNull(cboDiv) And IsNull(cboGender) Then stLinkCriteria = ("[Category]= '" & Me.cboByCategory & "' OR [ProdtSubCatLongDesc]='" & Me.cboByCategory & "'") stLinkCriteria2 = ("[Approved] = FALSE")...

Hi, I have 3 combo boxes on a form that I am filtering another form/report based on a table in VBA using stLinkCriteria This is all working fine but I also need to put a hard filter for 2 other fields in the same table where [Approved] = 0 and [Denied]=0. My Debug.Print shows [Category]=...

Think I've got it sorted out stLinkCriteria = "[Category]= '" & Me.cboByCategory & "' AND [Division]='" & Me.cboDiv & "' OR [ProdtSubCatLongDesc]='" & Me.cboByCategory & "' AND [Division]= '" & Me.cboDiv & "'" Added my other combo boxes to the first portion of the criteria, it was just looking...

Thanks for the tip, I did this and it looks like what I should expect but the form is not filtered for what is showing - [Category]= '2000 - CAMPING' OR [ProdtSubCatLongDesc]='2000 - CAMPING' AND [Division]= 'TENTS' AND [Gender]= 'MENS'

HI, apologies if my post appears twice, I did not see where my first one got posted. I have a form with 3 combo boxes that filter another form/report. The first combo (cboByCategory) contains options from 2 different fields within the same table. Before I added this add'l piece of code, all 3...

Pure genius!!! Thank you so much, that worked perfectly, was driving me crazy!

Hi, I'm having trouble with the below code - When I initially open the database and select an item in cboASR, I get this error message: Syntax error (missing operator) in query expression 'ASR User Id] = 'thart' OR' If I then select something in cboCust as well, it works fine, then I can go...

Solved my own problem. I had to add "Like" in front of my criteria in my query. Like [Forms]![frmMain]![cboType]. Thanks!

Hi, I have a query that is run after selecting a parameter from my combo box that then is exported to an Excel template. For my "All" selection I have the critieria as *. I cannot get the data to populate in Excel. I don't get an error mesage, it just comes up blank. Also, if I just try...