Search results

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

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

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

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

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

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

Hi If anyone can help, i'd be grateful. I'm trying to format a pivot table in an access query, in the same way in which excel automatically creates the table....but really struggling. Think i've been trying for too long. I have the following fields Item, Date, Invoice Qty, Total Amount...

Hi all. I'm tying to manually link tables via an ODBC link, however when I createa manual link the "_" between words is dissapearing. this means that any table names with multiple words separated by and _ won't link, and any single table names will. It is the same with field names. The form...

Hi I'm having problems with a database that is increasing in size simply by opening and closing it. I've read through the many posts on here about that, and looked through the code for open recordsets and queries etc, but can't find anything that looks like it is causing it. This is a database...

Hi. I'm trying to create a report with a chart in it, based on a query. I've been using the Report Chart Wizard, but not getting the results I want. I managed to get 1/2 way there, but the bizarre thing is that when I look at the report/chart in Design view, all I see is the sample chart (the...

Apologies if this has been asked before - I promise I've been searching for 1/2 hour and haven't found the answer. I have a combo box that I need to drop down automatically on gotFocus. Normally I would use Alt + Pg Down, but in this case it needs to open/drop down automatically. Can anyone...

Hi I'm recording information about people attending training courses. There are three tables 1 - tblStaff (StaffID, FirstName, Surname) 2 - tblCourse (CourseName) 3 - tblAttendance(StaffID,CourseName,Date) Table three is a many to many junction table as you can see. (This is a simplified version...

Hi Apologies if this has been covered before - I promised I have searched and not found an answer. I have just purchased the Access Development Extensions so that I can deploy my database's to users without Access. So far, I've managed to create an intallation file fine. Hwever, the database...

Hi All I've currently got a Customer Database and a PDA. Unfortunately they aren't talking to each other. Is there a way I can either get my Access DB to sync with the PDA directly, or sync via Outlook. (i.e. Sync the PDA with Outlook, and then sync Outlook with my Access DB). THe only...

Hi I have been asked to write a database that holds sensitive information (as many do) where different people have different accesses to tables/back end etc. This isn't a problem, and I can set up user groups etc. However, I've never done this on a network before. The users already log into...

Hi Can anyone recommend a cheap fax client which can be easily linked to Access. I have a client who currently uses Zetafax, but would like to find something cheaper. Any information would be gratefully received. Thanks

Hi Can anyone recommend a cheap fax client which can be easily linked to Access. I have a client who currently uses Zetafax, but would like to find something cheaper. Any information would be gratefully received. Thanks

Hi. can anyone help me. I've spent the last two hours getting no where. I have a tbl_Enquiry,tbl_EnquiryType and tbl_Questions On the main form (frm_Enquiry), depending on which enquiry type is chosen, will depend on which questions are displayed. this is a many to many relationship so I have a...