Search results

Hi Bob, yeah when i create the table i use the lookup option then, ie. on table 2 i choose lookup when i created drwgnosequence and selected the table 1 and the relevant field again, on customers, i choose lookup on drwgnosequence and drwgno to get the info from table 2 is this not right ?

Hi I have now created as a multifield index as you suggested but i still am having problems, heres a quick overview so you have an idea of what i am on about Table 1 - Drwg No Sequence (keyfield) Model Material etc etc Table 2 - ID Drwg No Sequence...

Many thanks Bob for your reply, i will have a go. i may be back again later with another question or two but thanks again, really appreciate your help

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

sorry,i thought that as i had no replies when i asked the question to reports forum i had posted it to the wrong forum so i resent it again to the vba forum apologies

Hey thanks for your reply. I have create a module with the code you have given and run the report again, now i get message 'object doesnt support this property or method' Basically i am trying to run a report based on a query, one of the fields is linked to 'dialog box' with the list of...

Re: code to open dialog box in a report not working I only have an event procedure for the open form and close form event, which opens the dialog box with the choices in it. I am using Access 2007 but i copied this code from a similar report i did in an earlier version of Access which worked...

Re: code to open dialog box in a report not working thanks for your reply, i have now got the following code '------------------------------------------------------------ ' Report_Open ' '------------------------------------------------------------ Private Sub Report_Open(Cancel As...

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

thanks George. one more question, last one promise! I still have fields to add to my enquiry database and again some of the questions will only be relevant/visible if the answer to a previous one is yes. do i just paste both lots of code into after update property (obviously changing the...

sorry George, as you can see i am a newbie to this, where do i put this code. is this additional code to what we already have. What will new code do. Many thanks Jane

Brilliant, your a star. i used the top line of the choices you gave me and it works If [Solids_ParticlesPresent] = True Then Can i ask another question. When i create the form, i obviously have shown all the questions, i notice that when i go into the form to add a record, the box is...

this line is highlighted If (([Solids_ParticlesPresent] = 'Y') Or ([Solids_ParticlesPresent] = 'y')) Then when i created the table, i chose the y/n box, when i create the form, it just comes up as tick box. maybe this is causing the problem Many thanks Jane

Hi many thanks for help with this. Please can you help further. i am now getting compile error, syntax error. my code now looks like this in the 'afterupdate property' Private Sub Solids_ParticlesPresent_AfterUpdate() If (([Solids_ParticlesPresent] = 'Y') Or...

Hi George, thank you, can i take you up on that I have so far created a form with the fields i have created so far. As i said in my initial question, if they answer 'y' to question - 'are there solids present' then i want them to answer 3 more questions relating to the solids, if they answer...

Many thanks George, i will have a go

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

thank you for your reply many thanks jane

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