Search results

Bank Details table defs: Sort Code (Primary Key, Indexed No Duplicates, Required) Linked to sort code in main table. Address 1, Address2, Town, County, Postcode. All data types are text. Data is viewed on a single form which shows customer details and bank sort code. When data is entered in...

Main is a linked table on SQL Server. Bank Details is a local table on access. Yes they do have an auto-join defined. Sort Code is the primary key on Bank Details table. Data type is 'nvachar'. I put the Bank Details table back on SQL server and this solved the issue but it took over a minute...

I've got a table "Main" running on SQL which is linked to a local table "Bank Details" on an Access front end. They are linked by a field named "Sort Code" which is the primary key in Bank Details. I can add a new record to bank details but when I enter the sort code in the Main table i get...

Have now sorted it. Thanks

I'm using the MkDir function on a command button which creates a new folder in the C: drive. Example: MkDir "C:\Export Folder" I'd like to be able to choose the file name and destination this is saved to so need to call the SaveAs dialog box if possible. Any suggestions how to do this? Thanks

Yeah I'm pretty sure it's the screen. Will check it out. Thanks.

Hi Ken That works perfectly! Thanks for helping me out yet again. Something else you might be able to answer for me: I have a database that opens fine on my laptop and home pc but when I try it to open it on the office pc the command buttons are all over the place and everything is pushed to...

I have one report I want to use as an invoice but have different record sources for it. For example I have a command button on a form which opens the report to show all of todays orders. On another form is a button to show the report for that particular customer. I need to change the record...

Thanks guys. I'll try it out and let you know.

I use the following code on a command button to save "Table1" as an excel spreadsheet called Table1.xls in a folder called export folder. Private Sub Command14_Click() stDocName = "Table1" DoCmd.TransferSpreadsheet [acExport], , stDocName, _ "C:\Export Folder\Table1.xls", 0 End Sub This...

Many thanks for your replies everyone and sorry for starting a debate about postcodes of all things! And it's true, a british postcode only ever has 3 characters after the space. The post will probably still reach it's destination without it but I'm not giving Royal Mail any excuses...

I have a field [Postcode] and I need to put a space in between the characters. For example: RG204QZ needs to be RG20 4QZ L75HG nees to be L7 5HG. As these are British postcodes the space is always before the third from last character. So I am using: Right([Postcode],3) but not sure how to put...

Yeah it makes sense, I'm just not sure if you can do it since you are dealing with fields rather than records. I could be very wrong of course so I'll keep looking for you. Do you know roughly how many fields you will be adding? Another option would be to add these fields now to your table...

So does the mailmerge work ok? I'm not sure you can get the code down by that much but will keep looking. Also have a look at this link http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html and scroll down to Super Easy Word Merge. This might have some tips. Let me know how you get on.

Can you post the code you have so I can see what you are trying to do? I had a big problem trying to merge to word on one of my databases. I found the easiest way was to replicate the word doc into the detail section of an access report. Works a treat!

Fixed it! Thanks for your help.

Ok, I see what you mean, thanks. Anyway I tried it and I still get Error 3020: Update or CancelUpdate without Addnew or Edit. When I debug it highlights the rs.update line. From what I can tell .edit is in the correct place.

Thanks for the reply. I've updated the code, putting in Else statements as follows, but I'm not sure about the MyLabel statement. Can you explain that to me.:confused: Option Compare Database Public Function fImportdata() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb() Set...

Sorry if this is long-winded but here goes: I have the following (example) recordset called "Import Query" that I am trying to update using code: First Name M1 M2 M3 M4 M5 James Y Y Y Peter Y George Y Y Y Y What I need to do is check each record to see which...

I've discovered why only one label was showing per page. The bottom margin was set at 214cm. I adjusted this and the labels are now on one page. However, it seems label wizard can't grasp the concept of continuous labels. It recognises the blank space at the end of each page which throws the...