Search results

Hi I have a report which prints invoices. There are some simple sums in the code behind the report (Report_Page) to calculate the VAT due (some invoices are for people outside the UK who don't pay VAT). The numbers look fine apart from the first invoice ie it doesn't do the sums until page 2...

Hi all I'm working in Access 2000 for the first time and all was well until I introduced a wizard-created Switchboard. I created the Order Entry database using the Access wizard and copied the Switchboard form and tables into my database. Since then I keep getting the following message...

Hi all I'm using Access to reformat some data - not what it's designed for I know but it's the only tool I have available at present. Basically I need to be able to lookup a field name and write some data to it. I've attached the bit of code where it's falling over. For ic = 1 To...

Hi all I've done a quick search and read that you can import XML files in Access XP and Access 2003. Can you do this with any other versions? TIA shay :cool:

Hi I've not used Access for a while and need some help... I'm writing code to import data from an Excel spreadsheet. The data will not necessarily be in the correct units, so the plan is to import the data to a temporary table, display all the determinands which are in the wrong units and give...

Hi I'm using a listbox with the multiselect property set to 1 (simple multiple selection). How do I reset the listbox ie clear the selection? Can't find anything in the help text. TIA shay :cool:

Hi all Report's written and working fine apart from one thing. It starts printing each section on a new page but, because in our efforts to save trees we have double-sided printers, I sometimes get two one-page section reports back-to-back but each one has to go to a different person! I need...

Hi How do you reset the hidden attribute once you've already set it to True and can no longer see the table in the Access window? shay :confused:

Hi Has anyone managed to sucessfully use their own command button to apply a filter? In my example, as soon as you click the Filter by form button, every other button is disabled and I can't use the Apply filter button! I'd prefer not to use a custom menu or toolbar so any suggestions...

I am writing a VB5 application which imports an Excel 97 worksheets into an Access 97 database. The code works fine except for one field on one worksheet. The first hundred or so values for this field is Text, thereafter it is numeric. After running the VB application, the imported table...

I'm using the Docmd.Transferspreadsheet method to import data from a spreadsheet which contains several worksheets. To select the worksheet to import, I have included the worksheet name as the final parameter of the DoCmd.Transferspreadsheet method. The only way I can get the code to work is to...