Search results

HI all, Although i have another topic at the moment, I'm starting another, as the issue seems to have changed as fixes have been attempted. As a result, I felt it may be better to make a fresh start in the topic thread, so that I can highlight exactly what's happening, and what we've done to...

Database consistantly corrupting, and primary key lose Hi All, I came back yesterday, after having a nice weekend, to find that work had somehow managed to do a number on the Access 2003 database we use. I'm not sure what they've done, but when i had a look at one of the tables, it was filled...

Hi all, I'm looking at importing data into a table from a spreadsheet. The spreadsheet will only contain a single column of data, while the table in Access will have a few more, some of which will would be will provided from the form the user is using to import the data, and some at a later...

Hi All, I have a query which exports to a excel file afterwards, however, it's not capturing all the data I need. I can see why it's not working as intended, but can't work out how to resolve it. My query is at the bottom, and I think the problem is the "(([tbl Master].ID)=[tblRequest].[Cost...

Hi All, I was wondering if there's a way to designate which currency is shown using the formatcurrency statement. i have a table with values in, but they are representative of the currency of the account they are linked to. As a result I have £, € and $ values in there. I'll be using a query...

Hi All, Is there anyway to rename, or define the name, of a sheet when you export a query to it? I'm producing a report which makes several queries to a table, but changes one variable for each export. Each query needs to be in a seperate sheet, but the same workbook and I need the sheets to...

Hi All, Hope someone can help me ehre. I've got a form which is being openned all I can see if half of the X button in the top right hand corner of the screen and a very small protion of the form. The total form shown is probably no bigger than 10x50 pixels in size. The form itself is Modal...

Hi All, Does anyone know if you can change the week display on a DTDicker from Monday-Sunday to Sunday-Saturday? Many thanks.

Hi All, I might be being really stupid here, but it's near the end of the day, and my brain just can't work it out :banghead: Basically, for some reason, on the Form i'm using, it only shows one result back on a filter, but when I enter it create a query with the same info, if displays what I...