Search results

I have a table with a numeric primary key field. Is it possible to create a select statement which returns a list of the records with the same whole number?? E.g 144.2 144.4 144.5 144.7 144.8 144.9 I need this as the Rowsource for a combo-box. Are there wildcards that I could use??

You need to create a recordset for the list of record you have, and create a loop which performs the action for each record. Dim rs As Recordset Dim RecordSetString As String RecordSetString = Form_YOURForm.recordsource Set rs = CurrentDb.OpenRecordset(RecordSetString) rs.MoveFirst Do...

Havign a bad day, should of thought of this.. thanks :)

Yeah I gave it a shot, but I get an error saying; "Wrong number of arguments used with function in query expression" Is this syntax you think I should have? DLookup("[STOCKID]", "[TBLStock]", "[Status] = 21 AND [PARTID] = 756005 AND DMIN([PODateStamp])")

Im wondering if it was possible to run a Dlookup to find a value based on certain criteria such as non-primary ID field AND where the date is the earliest available. I know you can do Min(Date) in a query, but is there any soution for a Dlookup? Cheers..

Thanks for that one I must of spent about 3 hours pulling my hair out with this issue. I was on the same wave length, but couldnt quite figure it out!

Sorry to dig up an old thread, but I am undertaking an almost indentical task. I have Access 2007, and Adobe Acrobat 8 Pro. I can make the pdf file save without an prompts, but I am unable to make the Caption of the report set to the ID field of the report. I have tried setting the value on...

I have created a Query which returns the correct results. But I need to assign the value of this query (its only a single field) to the value of a textbox on a click event. The query has a sum, which has criteria based on a related table, one of the criteria is dynamic. I have searched around...

Sorry if this has been covered before, I wasnt sure on the correct search word criteria. All I need is to format a textbox in a subform. The textbox is a integer data field E.g 1,2,3. If the text box is 1 then I want the text to display "In Stock", 2 "On Order. Etc.. Is this possible??

lol... Thanks pbaldy, I always frustrate myself over these stupid little problems.

Ive been trawling the forums looking for what I think should be a basic problem. All I need to do is pass a value into a textbox of a new form on DoCmd.OpenForm. Should I be using OpenArgs for this? I have tried but everytime the textbox has no value assigned to it. DoCmd.OpenForm...

thank you EMP, excatly what I needed!

[Resolved] Custom Order By? Wondering if it is possible to order by particular values?? That is I have a column (varchar) named "Status" with values such as; Entered, Active, Completed etc (I didnt design the DB). What I need is to order by Entered, then by Active then Completed etc.. Is this...

No thats different, if I were to use your example it would be; UnitID - ----101 ------101-------101---- Repair - New LCD - Batt Cover --Ribbon--

Is it possible to create a form which display its data left to right, rather than top to bottom. I have tried using the different form layouts (tabular, columnular etc) but its not what Im looking for. E.g This is what I need; Heading 1 - Data1 , Data2, Data3, Data4, Data5 Heading 2 - Data1...

Yes the combo box selected value will be different on each line. The row source is just a simple query. I need to be able to select different values for the same combo box on each line. The problem is, whenever I select a value EVERY line updates to what I have just selected.

They need to be in the detail. Each record has a combo box.

Ive have a continuous sub form with several combo boxes on each line. My problem is that whenever I select a value on one combo box, the combo box on every line updates. Is there a property or someway around this, or is it just not worth my effort?