Search results for query: *

I am running a number of macros that incorporate a lot of processes that often take quite a while to run. I know that we have the progress bar on the bottom of the screen but this only shows the progress of each query as it is run. I would like to be able put some kind of timer / graphic on...

I am trying to export a table to a text file, but the name of the file needs to be date / time stamped as it is continuously run. Can anyone help me with the code for this ? Thanks

I am trying to import a file to a table but the file has an extension of .01. Access won't import the file unless I change the extension to .txt first. Can I force it to import the .01 extension file as I need to avaoid any manual renaming prior to the import ?

Is there a way of creating the Form Pivot Table but only having gross tables for the rows and the columns and not for every different record in each field ?

I have a table with about 50,000 names that are used for multiple selection in a list box and then used to pull out additional contact information, however when selecting the names it can be fairly arduous due to the volume. Is there a control for an explorer style menu where I can split the...

I have a customer database and I am building a select query with criteria based upon the selection of multiple records from at least 4 list boxes on a form called "Search_Select". The idea is that one or more of the list boxes is used for the extraction of the data using multiple selection...

Is it actually possible to run a select query based upon a list box set up with multiple selection (Simple or extended) ??

Is it possible to create a Combo box that allows for multiple selections by holding down the control key when making the selection of the records ? If this is possible how is this selection of records applied to a select query.

Is it possible to have a TabControl within another TabControl, but only have it appear on a single tab. When I do this the inner tabControl appears on all the main tabs ?

I have combo box set up based upon a table (Maintenance)containing the subform name and various y/n fields. (one of which is to make the form visible / invisible - column 3 in the table). Each subform is merely a view of a listing table that users can update, amend or delete records. The idea...

Is is possible to export a table in a fixed width text format with values that right align to columns rather than left align ? Thanks

Is it possible to export a table as an Excel file but with fixed column widths ? Thanks

I need to get a message box to appear for the duration of a process and then clear itself at the end. Is there a VB clear message function or a way of putting on a timer to have the message up for say 10 seconds and then dissappear ? Thanks

Is there a way of resetting the autonumber on a data table after clearing down all the records ?

Is it possible to set a screen resolution for Access Forms that is independent of the screen resolutions set in Windows ? I am having to resize forms to fit different screen resolutions between laptops and PC's.

I want to be able to generate a report that expands laterally rather than vertically ( a bit like a MS Project Plan). I have a number of staff members and lots of dates, I want to be able to expand across the page for as many staff members are selected, and for the list of consecutive dates...

I have a table that contains a single record for recurring time entries. For example the time entry will have one date (say 1st May), and then have a field in the record that says that it recurs 10 times at weekly intervals, i.e. 10 recurences * weekly / daily indicaor etc . The application...

I am trying to put together a remittance advice but am having a really bad day !! I can get the account details under the transactions but am having a problem getting the page total in the Page footer section. I have the grouping on the account code to give a single page per account. Any ideas ??

I am running MS Access 2002, having migrated from 2000. Quite a few of my queries use the now() function, but this no longer works. It is quoted as a function from the build function in the queries and inserts it into a query just as before - so why is it now giving me the message 'compile...

I am trying to design a small database that records users logging into and out of an SQL based application. I have located the SQL table and the users and have already written the macro to record the relevant information to a history table. The problem is that I now need some sort of timer that...