Search results

This code sits behind a button, and the error only happens when this button is clicked, so i'm presuming this is where the error is. Thanks

HI I have some code which runs through a recordset and prints out external documents listed in that recordset. It is very old code that I have picked up from the original database (access 97)(we are now using Access 2010) and it seems to work fine in the accdb, but as soon as I create the...

HI I have now found a solution or work around to my problem that may be helpful to others. Instead of trying to link to the Excel table, go to the External Data tab, click Import the source data into a new table in the current database, then on the 3rd stage of the import wizard change the data...

Hi Thanks for your response, sorry I should have made it clear that it is a text field, so its the number of text characters that have been truncated, not a number. I was hoping that by just linking to the data and not importing, it would allow me to use all of the data that is needed in the...

Hi I'm trying to create a report in Access 2010 based on data stored in Excel. I have linked the excel table to access, but have found that some of the data has been truncated. I've been looking for work around for this all afternoon, and have seen lots of posts about reasons if you are...

Ignore my last message. Brain kicked back into gear and i've got the code in the right place. Thanks for your help

Thanks very much for the reply. I've tried the debugging and although I understand what you are saying, I'm being very thick and am still getting it wrong. I've put my reference to the EOOMID = rs!EOOMID in, but now i'm getting an error message that the Recordset is not updateable. As you can...

Hi I'm trying to send the contents of a recordset via individual emails to the same person. I can make this work if I'm attaching a report or if it's just one record, but for some reason I can't get the .movenext to work. The code will even send the correct number of emails, it's just sending...

Thanks very much. The demo from Taruz is great. I do know enough to be able to add to the code and update the text properties at the same time. I'm OK with editing code, just not writing it from scratch Thank you again for the responses.

Hi I've been doing some work on an existing database which has included adding several new forms. As a result of this DB growing over several versions of access there are now all sorts of random formatting options on the forms. Is there a way of updating all of the forms at the same size to a...

Hi I'm trying to create a booking form which prevents you double booking the material. I have a booking form (frmBookings) where you enter the [ProductID], [StartDate] of loan and [EndDate]. (tblBookings) I'm also displaying a subform sfrmBookings which shows all future bookings for the same...

Thanks, that does make sense, but even if I exported to excel and then imported again, i'd still have to pick up the new job number and use it in the import for the loads and vias etc. as it's still got to sit in 3 tables, that is the bit i'm struggling with.

Hi The database is controlling jobs for a delivery company. I have one table which store the job header, one which stores the details of the loads, and one which stores via points. One job can have many loads (although it is not normal), but one load can have many drop off points (vias)...

Thanksf or the response, but unfortunatley I need to keep them together, so that all jobs have a continuous jobid.

Hi. I am trying to copy a record which has data in 3 tables, and replicate it in the same set of tables, but with a different ID number. I know how to write an InsertInto statement, but what i'm not sure of, is how to copy the new id (that has been set by autonumber) into the other 2 tables, so...

Thank you so much. I was very close, but not using the brackets/"" correctly. Thanks.

Thanks for the information. This is a database i've inherited, but I think the reason that it is set up this way is because the address fields in the main record can be populated from multiple sources, either Suppliers, Customers or in this case Deliveries. I guess the answer would be to combine...

hi all I'm sure this is simple, but i'm really struggling, if anyone can point me in the right direction, i'd be grateful. I've got an open form which needs to be populated with an existing address. Whilst the original form (based on table tblDelivery) stays open with a part completed record...

Thanks for the responses. The control that holds this code is in the subform and it's behind the On Click event. I agree that it's not a normal form/subfom relationship in this sense. The main form is where a user would enter the information for a price request (i.e, Material, Customer and...

Hi All I've got a really strange problem with a form that I can't work out, and wondered if anyone could help me. I have a form with a subform. When a field in the subform is clicked, the mainform updates to show the details. The code i'm using is Me.Parent.RecordSource = "SELECT...