Search results for query: *

Hello, Does anybody know where I can find a good 'bolt-on' drive and file list selection form that I can use in my application? Ricky To say 'thankyou' encourages others.

Hello all of you helpers, I have a problem trying to update a table from a list of parts in a sub form. I will try to explain: I have a table of parts. I have an assembly which contains some of the parts in this table which shows a quantity to be extracted from the parts table via a query. I...

Hello, I have a problem with printing a report (invoice) which is linked through a sub-form to a form which contains the customer details. The first one I create is fine, but when I create a second one, even if its for another customer it copies to the second page of the same report and so on...

Hello, I need to configure a reliable way of creating incremented invoice numbers from a button_click into a text box backed up from a table. Does anybody have a method that they have proved to be reliable? Regards Inky "To say 'thankyou' encourages others."

Hello all, I have an interesting problem for you experts to get your teeth into. I am creating a stock control database. I have a Parts table (PartsTBL) and an Assembly table (AssyTBL) which contains parts collected together from the PartsTBL. I need to update the actual stock levels in the...

Hello, I am unable to insert the date from a calendar control into a form text box. It seems that it does enter into the underlying table but will not show on the form. I have a seperate form that the calendar is on and a button that opens the form where the date is selected after which the...

Hello, I have a very annoying problem. I am trying to populate a text box with the system date by putting coding on a button. But it will not work no matter how hard I try. I would pull my hair out if I had some! The code I have is on the Click event: Dim DateToday As Date DateToday=Date...

Hello, I have a customer who is requesting a facility to be able to update his Access application on his laptop via a modem on line to his main Access application tables on his server/hard drive at his office. What would you advise is the best way to go about this? Regards Ian "To say...

Hello, Is there any way that Access can create a stand alone exe file yet. Where the user does not have to have Access installed? Regards "To say 'thankyou' encourages others."

Hello, I need to find the code for converting files at present stored on a Canon StarWriter to be imported to Access. I understand that a conversion program is available but I am unable to find it. Canon are not being any help. Can anybody help? Regards Ian "To say 'thankyou' encourages...

Hello, I need to import several Excel spreadsheet FILES into one Access database. Is it possible to differentiate between them in the database? Perhaps with VBA coding. Can anybody give me an answer? Regards Ian "To say 'thankyou' encourages others."

Hello, I need to import several Excel spreadsheets into one database. Is there anyway that I can read the title of the spreadsheet in order to place it in its own category within Access, or perhaps you can think of another way of doing this. Effectively I need to be able to have several...

Hello all, I have a client who requires me to import specific pages of a particular format of Excel spreadsheets into Access. I need to make this action as simple as possible for the user (ie just one click of a button, or maybe be able to select within the Explorer structure). I would...

I have a customer who wishes (against my opinion) to update an external Excel spreadsheet with data from an Access database when exiting the database, so that his spreadsheet is always up to date. I have advised that he can do all that he wants to do within Access but he insists. How can I...

Why is the copy of an Access database that I saved onto CD-ROM Read-Only when copied onto another hard drive? If the same file is saved to floppy disc it is not. Does anybody know how to overcome this? Looking forward to hearing from you. Regards Ian Richards "To say 'thankyou' encourages...

I feel rather silly as I am sure that I have carried out this task before. I am trying to create an Autokey that will reference the controls in a sub-form. E.g. ^n to move to the next record in the Sub-Form and not its parent form. Even when the sub-form has the focus it still carries out the...

Hello, I need to output e-mail addresses to Outlook. I can output to an external file such as Notepad, Word, Excel, but how can I output this to an Outlook file which is acceptable to the Outlook format such as "Address1; Address2; Address3;" etc. to be picked up by the Outlook user...

Can anyone advise me? I registered my domain name in March (?)2002 with Sumbit Wizard of MyComputer.com and paid a yearly sum in order for them to supposedly register my web page with 200 search engines. Since then I have not had one hit one my web page and contact with the company does nothing...

Hello, I want to be able to select a record from a datasheet or form and, on clicking a button, copy that record into a table or a report to create a suppliers order from a list of materials shown under that suppliers filter. Any suggestions as to how to do this? I prefer this in VBA but SQL...

Hello all you genius's out there, I have heard that it is possible to install Access 97 and 2000 on the same machine to meet different customers requirements. Is this possible? If it is do I need to partition my hard drive to do this? If I do not doesn't it cause aproblem with the different...