Search results

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

Hi, I am trying to Sum two fields in my query with an IIf statement that only applies to one of the fields. I keep getting syntax errors and can't figure it out. Calc Rjct Qty: Sum(([OM Rjct Qty],IIf([Rjct Sched Rsn Cd] In ('Z4','Z5','Z6','Z7','Z8'))+[Uncnfm Qty],0)) Want to Sum OM Rjct...

Thanks for the quick responses! After pulling in just the Ord Entr Qty and matching it to the Rjct Qty, I just realized that my calculation is actually working - I should be getting all zero values! Not what I was expecting but at least I now know the formula is correct. Thank you so much...

Hi there, can't seem to figure this out. I am getting all zero's in this query calculation. Both Ord Entr Qty and OM Rjct Qty are number data types (Long Integer). Rjct Qty: IIf([Rjct Sched Rsn Cd] In ('Z4','Z5','Z6','Z7','Z8'),[Ord Entr Qty]-[OM Rjct Qty],0) Without the calculation it works...

Not sure if this is even possible but I am attempting it anyway. I have Form1 with a listbox (lstView) that is populated from a combo box value - no problems there. cboReport - User selects name of report lstView - Populated in AfterUpdate of combo with list of "Views" the selected report...

Hi, I am creating a survey database and cannot get the combo box for answers to tie into the questionid #. I have 41 questions - t_questions: questionid question t_responseList questionid responsetext t_responses userid questionid responseid I am trying to build a continuous form that...