Search results

CJ I was wondering if you could help again. I have now managed to get the transfertext command to get the data into a "temp" table. How would i now go about writing a query to append the "primary registrant" to one table and the "additional registrants" to the other table whilst keeping them...

I am now having to revisit this as the number of registrations expected for the show is a lot higher than initially forecast, so having the ability to import into the database would be very helpful. I have tried following the link and reading the transfertext info, but it seems a bit over my...

Hi Lightwave Thanks for the reply. The form in questions "frm_ScanAttendees" only has a text box on it with an OnEnter event that runs the Update Query. So there is nothing there for me to run Me.Attended against, as that data is just contained in a table. What i need to be able to do is...

Hi again all, Still working on the registration and badge print system for their upcoming exhbition the company I do a bit of work for. Managed to solve most of my problems but have got stuck here, just cant figure my head around it. Basically each of the badges have a barcode (code 39) on...

Thanks again for the info. I don't do databases all that often and when I come to doing them I find i Have forgotten everything I learnt the last time. So I apologise for asking lost of questions.... but... I am so confused in my thinking haha. Basically as I have explained each...

Thanks for the link CJ. Have done a bit of VBA before, can generally get my head around it once pointed in the right direct (or can usually google an answer lol). Can you just point me in the right direction if you have used this function before. Basically I just need to know how to use the...

The company I freelance for (doing graphic design not databases lol) has asked me to build a database for an exhibition they are running with the following brief; The people will register through the website. My current plan is just for a webform to submit the data to a newly set up email...

Hi Paul, I dont know where I went wrong but I went back to an old version I had saved prior to dropping the 2 location tables and then reworked from there and just used the dcount function, keeping my 3 location tables, and all is now working how is required so hopefully we can stick with this...

HELP HELP HELP Sorry Paul... following you advice on the query front I decided to Base ALL of my forms and reports on separate queries rather than embedded. I now have just 1 loactions table which is in my Relationships window twice as LocationMaster and LocationMaster_1, each of the Primary...

Right... ignore me, I am thick lol. I just built a query as you said and then based the report on that query and it works great.. Thankyou. gracias por su ayuda

Paul, It appears my thanks were a little premature. i am sure the advice and direction you have given is spot on, I am just a little thick!!! HaHa. I have added a second instance of the Locations table to the query (it is an embedded query, will that make a difference), I then link the Primary...

Thank you so much to everyone. I have not had chance to try these options out yet, but I suspect with the advice I will be dropping the 3 tables back to just a single one as it will solve A LOT of the problems I have been having, now that I know how to do so. If it doesn't work I will try the...

The reason for the two tables was because of an issue I was having with a report. The main report, or Job Sheet as they refer to it as, has both the collection and drop off locations on it. the report is based on the Jobs & Booking table, so therefore the only data it displays as standard are...

Hello all... again, I am trying to get something to work using VBA, but I am really struggling. I presume it can be done, but I thought I should defer to the experts to find out. The DB is a booking system for a chauffeur company. The are numerous tables, but the important 4 regarding my...

Thank you so much, that works an absolute treat. Much appreciated. Cheers Si

Hello all, I have some code (which I will post below), that outputs one of my reports to a specific location as a PDF and also names the file based on 2 fields within the current form... [Job Number] and [Client Name]. My issue is that when the Client name has a SPACE in it, the PDF is saved...

thanks nigel, can you remember the name of the thread? cheers

Hello all. I have followed the other threads on here regarding using VBA to add appointments to outlook and it works great, everything works a treat, but ONLY if I have opened Outlook and have it running. If I dont open it prior to the code running then the appointment is not created. The...

Hello all, The database is for a booking system for a chauffeur company. I am trying create a query that shows all the completed jobs or cancelled jobs. The table layout might be a bit complicated to explain so I will post a screen grab of my relationships diagram. Basically the query I am...

Hi cpl, No worries if you are busy. I may just strip it back to table state and go again from there. I think I might have figured out a way for doing what I want by using sub forms and a button back with a line of vba. I will let you know how I get on. Cheers Si