Recent content by Delid4ve

sorted: DLookup("[F-GasLogID]", "[F-GasLogs]", "cdbl([actiondate]) = " & cdbl(Forms![F-GasLog_Add].Form.[Actiondate]) & "") Thx guys, been messing with me all day.

its got more to go in the dlookup, but at the moment im just testing in the immediate window. But yes, thats where it will be when it works. I know that doesnt at the mo. I do definately believe its a US to UK problem, ive seen this in various threads arount tinternet, however i still cant...

Ive also checked this on a query: SELECT [F-GasLogs].[F-GasLogID], [F-GasLogs].ActionDate FROM [F-GasLogs] WHERE ((([F-GasLogs].ActionDate)=#9/6/2011#)); and it works perfect **** Just attached stripped down with just that table and sub form.

yes they are. they are all unique values as well, no other row has the same date (even though this should still return the first value i believe).

Coming accross something strange and i dont know whats going on. So i am using a lookup on a table and checking a date field. Certain dates work, certain dates dont and i cant work out why. DLookup("[F-GasLogID]", "[F-GasLogs]", "[actiondate] = #" &...

Just an update on how i fixed it for any future searches: Set all the filtering on 1 combo and the other combos just called the event procedure for that combo: Private Sub Cylinder_Type_AfterUpdate() Select Case Me.Cylinder_Type.Value Case "" Me.Cylinders_SupplierDetails.Form.RecordSource =...

So, I know how to create cascading combos, I know how to create not in list to add new data. The part im stuck on is how to combine them in this situation. I have a form for input of issue records for an employee for Equipment (which is a subform). Equipment need to be selected from combos...

Right, so scrap that idea, ive changed to filtering the query. Got the afterupdates working for a couple of combos see below, what id like to do now though is cascade the filtering. How? Ive had a read about but cannot find anything specific as everything i search relates to cascading combos...

Trying for ages to get this right but keep getting errors. Main Form: Suppliermaster Sub Form: SupplierSub Queries for sub form record source: OFN_DocumentsMaster , Refrigerants_Documents_Master Main form Combo Name: CylinderType List Options: "OFN", "Refrigerants" When selecting one of the...

Just finished the first stage of my database, lots of data entered, working as planned. Made a backup (thank god), then run compact and repair. On running it produced a table - MSysCompactError Errorcode: -1611 ErrorDescription: The Microsoft Access database engine stopped the process because...

have changed to show you slightly. I think you'd be better off with one table for quotes/orders and probably still to be added is invoices. have a look at the relationships window now

Tablenames/fields/querys/forms very confusing and no standard in place for naming. Im not sure your tables are correct either. You seem to have an orderdetails table, which i assume is meant to be a junction table between stocklist and orders but only one relationship. Would a quote relate to...

Think this maybe what you need: Allow value list edits: Yes Limit to list: Yes After Update Event: 'Get confirmation that this is not just a spelling error. StrTmp = "Add '" & NewData & "' Add data as a new product/order?" If MsgBox(StrTmp, vbYesNo + vbDefaultButton2 + vbQuestion, "Not in...

Managed to solve this myself: For the afterupdate of the combo box selecting the documenttype had to include: Select Case Me.DocumentType.Value Case "Engineers Log" If IsNull(Me.[DocumentNumber]) Or [DocumentNumber] = "" Then Me.DocumentNumber = Val(Me.DocumentID) Case Else End Select

Think your missing what im saying. A collection note comes in, we select the document type(lookuplist), then input the document number, etc etc An engineers log comes in, we select engineers log from the document type, we cannot input a document number as it doesnt have one, we need to...