Search results

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] = #" &...

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

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

Hi Guys. Have a form for logging documents. One document type is employee generated and does not have a unique number(field is indexed, no duplicates) What i need is for this document type to auto populate with a number(easiest way i see to use the document ID autonumber) Document type is...

keep short and simple, struggling to find a definative way to input this on web.. i have a combo that is bound to a set list, each selection sets a number of other combos visibility to either true or false. moving records this does not happen. i know i need it to requery but where and how? i...

I have a case statement to show hide fields as applicable. I need to hide/show a couple of fields in the subform based on the main form selection but cannot work out how i have to reference this in my statement. Mani Form = Record Subform = Record_Cylinders Field to hide = QtyUsedRecovered...

Ive done alot of reading and am starting to understand to record source, control source and row source values. However im struggling with the master/child relationship. If i have 3 tables to which my form is produced from: Documents DocumentID(PK) .... DocumentDetails DocumentID(PK)...

I have a sub form to which the tables have referential integrity checked. There are two PKs in this sub form that i need to update on the fly. the relationship is as follows: Refrigeranttype,RefrigerantID(pk) 1-~ Cylinderserialno(pk), RefrigerantID(Fk), Tareweight, netqty When i add a new...

Hi Guys, After consolidating/rewriting all my sub queries to remove grouping and merge into one on testing I have realised that i need to break it down slightly. Been trying for hours now to get the result I need but now is the time to ask for help. HELP!! Or even shout:p The current Result I...

Hi All Ive got all my tables sorted now for a work database project but am struggling a little with the query side. Im calculating holiday entitlement for employees based on numerous factors and would like some help combining queries Today is my first day ever writing SQL so please bear with...

Hi all Attached is a copy of the database with the form present and working. However, i require two further combo boxes from two tables which i cannot get working for the life of me. :banghead: If i add in the wizard(yes im not able to quickly write the source *yet) then a: i lose the ability...

Further to my original post regarding multiple many to many relationships I have started a fresh and am relating my data to the customer/product/supplier/order model that most tutorials are based on. For the basics it fits my purpose, well, as far as I've got anyway and is helping me create the...

Firstly apologies if this is in the wrong place, I have a sub form with a combo box that selects from another table, if not in the list it gets added to the source table as follows: Private Sub Combo8_NotInList(NewData As String, Response As Integer) Dim strTmp As String 'Get...

Hi all, a long time since I've used access but having to build a database to store our company refrigerant logs and whilst I have the majority suss'd im struggling in one area which I hope somebody can shed some light because my brain is going into meltdown. The purpose of the database is to...