Search results for query: *

Hi all, Can anyone tell me why Access is reseting my autonumber fields to 0 everytime I move the db from one computer to another? Can I stop it from doing this? It is messing up my order system because the reset autonumber is making duplicate entries in my primary key field. Thanks for the...

Now, I'll start again... Is there any way that I can tell Access to leave my form sizes alone? I would like every form and report to open in the size that I saved it as. Access seems to like maximizing and restoring withough consulting me. Thanks

AAAAAHHHHH!!!!! Access is enraging me!!! Everytime I get all my forms set to a nice size, Access either changes the size or maximize it or does some other darn thing to make it look like crap. Is there any way that I can tell Access to leave my darn form sizes alone?

Hi all, Can someone tell me if it is possible to group records by month? I would like my query to show the sum of clientordertotals ($) by month. For example: January: $500 February: $1000 However, I can't seem to get Access to group by month. Thanks for your help!

Hi all, I pretty sure that this is a simple question but it'd the details that I don't know. My db need to create and destroy a table during one of the transactions. I need to create some thing (module, macro etc..) that will create a table automatically. Here are the specifics...

Hi all!! I am having some trouble with an order form. The form consists of the main form (ClientOrder) which is used to select the client's company address and contact info, and the subform (ClientOrder subform) which is used to select the products and amount. The subform is in datasheet...

Hi all, I have a sales form that list the client's name/address with a subform that is used to make the invoice. The subform is displayed in datasheet view and has the following columns (Product_ID, Product_Description, Product_Cost, Number_of_Units, (Row Subtotal =...

Hi all! I had a nice relationships table with all my relationships defined between the main entities. However, after a whole bunch of designing of forms and adding features, my relationships window has become cluttered with a load of relationships that I do not recognize. Some are names of...

Hi all! Firstly, thanks to all the good people who have answered my numerous questions :) Second, my problem: I would like to query my employee and employee_type (eng, adm, sci ect..) using a parameter to tell the query what kind of employee records I want returned. For example: list all...

Hi all, I want to use a lookup wizard in my orders table to select the company's client_ID. I can do this, but I was wondering: does Access generate the lookup field once and save it, or does it lookup the values each time so that new clients are on the list? Thanks, Vince

Hi all, I am in dire need of some help! I would like to replace the drab little password dialog box that pops up for the db password with my own form that will have a nice picture, title and a textbox to enter the password. Can anyone tell me how I would go about over-writing the standard...

Hi all, I would like to change the small, drab password prompt box into a nice splash page with a textbox for the password. Is this box changeable or would I have to design a new form and somehow embed the password function into it? Thanks :)

Hi all, I am in the process of constructing a database that tracks business categories by province and city. I would like to have a table with all the cities in Canada but I really don't want to have to identify each one separately, that would take far too long. Does anyone know where I...

Alright, I'm going to post this question once more and see what comes of it. I have my database password-protected. When I open the database, it asks for a password. This is just great. However, it is also asking for a password when I close the database which is super annoying if I want to...

Hi all, I am trying to password-protect my Access 2000 database but it's acting funny. I want Access to prompt for a password when I open the database, but as it is, it is asking for the password when I open the database AND when I close the database. I don't want it to prompt for a...

Hi all, I am building a report which displays [item_description],[item_cost], and [item_contributor_ID]. I've managed to make a textbox in the report footer which sums the [item_cost] column to give a total cost of all items that were bought. My problem is: I would like to have another...

Hi all, Can anyone tell me why my database asks for the password when it closes? I have it set to compact on close; is this the reason?

Hi all, I would like to make a simple transaction database. Inventory and orders. When an order is processed, the related inventory goes down by the order amount. However, I cannot figure out how to get my order form to update only one cell rather than the entire atribute column. I was...

Hi all, I am making a simple database to keep track of my credit cards and accounts. There are two tables: Accounts and Transactions. Accounts:(Acct_ID, Acct_Name, Acct_Bal) Transactions:(Trans_ID, Trans_date, Trans_Amount, Acct_ID) I would like to create a form in which I enter the...

Hi all, I have a membership database that I've been designing and it is just about ready to use. I have been adding and deleting records as I test things and now the autonumber is at a high value. There are about 50 actual records in there right now and I don't want to have to reinput them...