Search results

I have a form and would like to hide some of the fields based on other fields being answered. For example some of fields on form : 1) is pump to be repaired by woking - yes/no box 2) is pump to be repaired by distributor - yes/no box 3) date sent to manufacturer 4) date repair report...

Hi, I am creating a database and one of my fields is called 'LogDate'. I have another field that is called 'follow-up date' and i want it to be the value of the 'log date' + 3 days. I have tried using the 'default value' to automate this but it keeps erroring. I have managed to get the field...

Hi, i am creating a new database. here is a brief description Table 1 - DrawingNoSequence (Primary Key) ie 6054 Supplier Model Table 2 - DrawingNoSequence (Primary Key) ie 6054 DrawingNo (Primary Key) ie 1 Revision (Primary Key)...

Hi there, i have created a report linked to a query. one of the query fields refers to a 'dialogbox' for its choices I have added the following code in the properties of the report in the 'on open' ' Report_Open ' '------------------------------------------------------------ Private Sub...

Hi, i am creating a database, an enquiry sheet One of the questions is:- Are there any solids in the fluid and the answer is either y or n If they answer y then they need to fill in the next 3 fields what size are they are they hard or soft What concentration are they when i create my...

i am creating an enquiry database, it will comprise of about 60 fields. can this all be in one table or should i split it down to more than one table. here is a sample of some of the fields i am creating what sort of pump do u require (answer will be a dropdown table) what is the fluid...

Hi, i have imported a spreadsheet from Excel into Access 2007. it is a product selector guide and has approx 35 columns, When i imported it into access, i went into the table and each time i went into a column i was able to filter each column, which is what i want the end user to do, so that...

Hi, i have a report which works from the underlying query like this it asks for start date and end date or blank for all (this works fine) then it asks for status of quotation, ie live, dead or order or blank for all (this works fine) the final part brings up a dialog box for the operator to...

Hi guys hope you can help I am creating an enquiry log form. is this possible for multiple users to use (or will it show as locked if someone else is already logged into database) each time a new enquiry is logged i want the number to jump up one automatically, ie. 1, 2,3,4 and enquiry date...