Hello, I am a new user of MS Access and is completely new to this forum as well. I am looking for some help on my first application in access that I am...

I have Windows Vista Home Premium 64-bit running on my HP Pavilion dv-1183cl Notebook PC. I also am using MS 2007 Office. I have been looking for a...

I have a query (running the query under queries) that works fine with where nz(amount)0 however when I use currentdb.execute "Update amount=0 where...

Hi i was wondering if anybody can point me in the right direction. I would like to know if there is anyway of using a yes/no box that when a user changes its...

Hello, I'm new to access and trying to learn by reading and trying... I would like to use a primary key ID in a table that would be the current year - 0001...

Hello, I have a report based on a table called projects, and I wish to include only the most recent record from a subform called communications. I figure...

I am a relatively new user to access. I am having a problem. I have 2 tables, each table has the same field and it is formatted as text. I need to be able to...

Real Estate - Free post Your ads about property for sale. You can join for free and post your ads about property for sale or for rent. www.World-Estate.com

How can I filter a database to leave only instances of the same entry more than once in column b where column a is different? That is, where column a shows...

Exporting data is pretty standard, I imagine but can A03 be set to save to a desktop via a relative path so that the file works no matter what computer we're...

Hope you can point me in the right direction. For simplicity's sake, assume one table with the following fields; table_customers fld_customerID...

I'm trying to figure out how to iterate through the results of a query, perform some logical evaluations at certain points in the process, and return the...

I am trying to use a query (q_OpSupSecurity) with a 'IsNull' to limit input to a textbox. The query is based on a table where Operators =1 and Supervisors =...

I am in the process of building a db for my manufacturing plant. The Database will help in determining employee efficiency. it is almost done until i ran into...

I have two questions: First, what is the difference (if there is one) between the "medium" macro security level in Access 2002 and Access 2003? Second, I've...

Hi out there, I have various tables with various OLE-Objects. So I mentioned ExtractInventoryOLE from Steven Lebans is the right tool for me. I did an...

I am trying to create a subform on a master form, in the past when using the subform from the toobox I am prompted to use the wizard for creating a...

I have a simple calculation form wherein I would like to trap a "/", "*", "-" or "+" then move the focus to the next control and then insert the...

Hi, I know my way around Access 2003 good enough to make some fairly simple databases, reports, pivot charts, etc, but I'm not sure how to work on this next...

Hello My database has 2000 to 3000 records. My staff does not know how to use queries and expressions to filter it. How could I create one simple form with 2...