I have an access database that has a number of tables, queries and reports. When my user went in yesterday, everything was gone. I restored the file from...

I have a query based on date. The criteria in the date filed is Date()-1. This works OK for Tuesday thru Friday but we're closed Sat and Sun. So on Monday...

We are looking for a system to manage work requests and placements The intention of the system is three-fold: Firstly, to keep a profile of each client and...

Hi all - Access 97 Rather late in the day I have discovered (not surprisingly) a flaw in the table design of my first database (probably not the only...

Hi all, Access 97 I have two tables, T_Clients and T_Tasks. T_Clients has an autonumber primary key field ID_Clients T_Clients also has an indexed field...

Hi all, Access 97 Nearly there. I now have two tables T_Clients and T_Tasks containing autonumber primary keys ID_Clients and ID_Tasks. ID_Clients is...

I'm trying to selected a record in a listbox based on a record from another form. When I click on the command button I want to highlight the row in the...

That's understandable. But what if we need an autonumbering type of number that corresponds to a tab in a binder - and the Access db is partly to make up an...

When I create a table/query to use AUTONUMBER the numbering starts at 22, not 1. How do I change this? -- smags

Hello, What I need is in each record of a form to be able to add the data of one field to another field. For example: There is the field F1 and the...

I have been asked at my job to come up with an answer to this question: we have a database that I designed that keeps track of basic inventory items, the db...

Is there a better way to code this, Like a global command or something? Thanks DS Private Sub Command43_Click() On Error GoTo...

I have a d/b with a table containing over 1000 tropical fish, I need to manage the stock of this table. Ie I need to know what my current stock is, how many of...

Hello ! I have never used Access before. A friend of mine set up the program for me so that I can enter new names/addresses into a database and then print...

access seems to change the format of date fields just for editing e.g 20-Sept-05 (defined format) becomes 20/09/2005 13:07:00 (whilst editing) it's not the...

Hi, how can I reach a query that exists in my access db, eg "simpleSql", from code. Thanx alek_mil

hi all i moved my preamble to the bottom so you don't have to read it if you are short on time. here is one problem i cannot fix in my app. table:...

I am trying to save my table. Each time I do, I get an error message that says too many fields defined. Right now I have 75 fields--I thought the limit was...

What built in function will change the sign of a number from + to -. -- Thanks Joe Cilinceon

I have several combo boxes with common phrases that concatenate into a memo field. This works fine except for one problem: even though I have included...