Search results

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

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

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

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

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

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

Hi, I have been using the below that I found on this site years ago on a search form. I recently pulled it into a 2007 db and it will not work. It works in 2010 but, when I imported the form and code into a 2007 db, the reference to "Microsoft Forms 2.0 Object Library" gets removed. I found it...

Hi, I have a form with 4 tabs each with a subform. They are linked to field "ID" on the main form. On the 4th tab I have a subform (Form1) and a listbox (List26) that I am filling with a query but I can't get it to change when my project (ID) # changes. I have gone into the query and tried...

I am trying to get the below to work to loop through my listbox (List2) and append the new records to my table. It will only append the 1st record added to the listbox but is appending it multiple times based on how many items are selected. For example I have the following items in the list box...

Cannot figure out why this won't work. Tried looking at several DSum examples but either get an error or no data at all. I have a report grouped on "Initiative Nm". The "Initiative Nm" text box is under the Initiative Nm header. I placed a text box in that same header area with a DSum...

Hi there, I've looked at many posts where they are using blnHeaderRow = True but I can't get it to work for me. No errors, just won't bring over the headers from my Access query. I've tried placing the line everywhere in my code with no success. Any ideas as to where i might be going wrong here...

Hi there, I need to get the equivalent of the Nz function below so that I can connect my query to an Excel workbook. Since Excel does not allow Nz. Expr1: Sum(Nz([Late (22 - 28 Days Late)],0)+Nz([Late Qty (> 28 Days Late)],0)) Trying something like this but can't get it working-would...

Thought this would be easy, but getting error message Want to run an import spec that imports and appends data from Excel to my Access table. I ran the import process, saved the import spec, naming it "Import-PGI_Data" then, in my VBA for my button: DoCmd.RunSavedImportExport...