Search results

Hi Ezio, That should be an easy one. First you need to join all 3 tables in a select query [Student].[Student ID] joining [Enrolment].[StudentID] and [Enrolment].[Unit Code] joining [Unit].[Unit Code] Once you have them in a chain, drag the Student ID, Name, family Name down to the query...

I suggest a drop down box would be better. This is because it will give you a bigger scope (e.g. if you have more statuses in future, a drop down can fit much more without re-doing the form with those fiddly option buttons. And the drop down box can draw the data from the status table. Bonus!

Hi Christine, I don't know if this will fit the purpose: in the equipment table you could add an extra field called "status". The status of a piece of equipment could be "live", "in repair", "disposed", etc. (you can of course create a new table called "status" and store those status values...

Hi kike79, Sorry to be ignorant, could you please explain what is Me.Para? Is it a field on a form? I thought maybe you should use a string variable holding the email addresses, and then assign it to the form field afterwards. So it should be like this. Dim str_Para As String '---initalise...

Hi dferreira, In the past, we used Windows API to callup the common dialog box in order to obtain a filepath. This has become problematic with 32 and 64 bit versions of windows. Its much easier nowadays to use the Microsoft Office FileDialog because its independent of the OS. (I've tried it on...

Hi GaryPanic, Don't give up. You are almost there. What error did you see and why didn't it work? BTW. when you are referring to a field in a recordset/table, try using this notation recorderset("fieldname") e.g. With MulitquoteCovertbl .AddNew !QuoteNo = MultisysQry("QuoteNo") Apologies...

You are right, its cleaner using codes - I apologise that I have misunderstood and not read your post properly. To use code, you will need to open 2 recordsets, one for the existing select query (source data) and one for the CoverMain table (destination) Simply refer the select query as if it...

Hi GaryPanic, You might just be able to do all this with an append query. First you create a select query with the Quote table and the fields that you wish to append to the CoverMain table. Then you change the query type from select query to an append query, and you will be asked which table...

Yes - good thinking! As long as it does the job safely then its a solution! You are welcome and hope to see you around again soon.

Hi sseto23, Ok, I've churned out some codes that should do the job - I am no VBA expert so my code is a bit crude and not fancy, but it should show you the speed improvement that you are looking for. I've kept it simple, the idea is to: create a one-dimensional array, loading the holidays...

Hi exceii, I am not so hot with macros (have been converted to VBA :rolleyes: ), but my guess would be to use the "After Insert" event property of the form, and then use SetValue in a macro to assign the Invoice DMax value to the InvoiceID box.

Hi sseto23, Just as a quick hack... try this: Replace the line in your function PlusWorkdays() to and run some timing test, and also check if it gives the correct date.

Hi Manc, The code you quoted, opens a report "rptQuote". Can I assume that this report is based on a query to draw its data from? Also can I assume that somewhere in that query, there should be a field

Thanks. I am glad it worked out and sorry for giving the correct solution a bit late. Do come back here if you have more questions. Good luck with your database project!

Hi exceii, Keep at it - don't give up. I think you are almost there. Just to check, can you type this in the VBA immediate window debug.print DMax ("InvoiceID", "Invoices") That should give you the maximum Invoice ID and all is well. I just re-read your post and realised that you should...

Dear sseto23, As already suggested by the experts here, currently the delay is caused by the DLookup disk access to the table. You should try to load the tbl_Holidays table into a global array. This loads the dates in the memory. You only need to do this once. Then when you are searching...

Dear mubi_masti, Now we are getting somewhere, you begin to explain what you are trying to do and express your requirement. From what I understand now, you are trying to fill a timetable, visually it is like this if you don't mind my own arrangement.... I am assuming that: a) at any...

Hi exceii, If a query is asking for a parameter, this usually means that one of your fields is referring to something that the query does't know. I think [InvoiceIDMaxQ].[InvoiceIDMax] is in doubt. As an experiment, if you change [InvoiceIDMaxQ].[InvoiceIDMax] to a value of "999", I think that...

Hi Carrie, Interesting project you have there. Your success depends vastly on the differences of the filenames vs. the UPC code that you already have in excel or in an access table. Firstly I hope all the images are in the same directory, if not copy them to a single location for backup and...

Hi mubi_masti, No I have not miss a point – that’s why I am the one that who can create solutions according to everything you have asked. :( I am trying to help – but your problem is that you do not explain what you have as the source data, the correlation of the data and what you are trying...