Hi I am using below vb.net code to insert a record into an access table and then retrieve the auto number id using @@Identity; If LocalConn.State =...

Hi, Access 2002 Anyone give me information on how I can get access to Rounddown numbers in a calculated query? I am calculating ages and I just want to know...

I have a mainform with two subforms, all driven by different tables. On the one subform, when the operation clicks an option (there are 17 of them), I have...

I have a 2007 Access database on my laptop that I've put as shared so it appears on the wireless network and can be seen by another laptop. The permissions...

I have a normalized table like below. This isn't my request, and I know it doesn't make a lot of sense...but customer is always right?? ID Question ...

Hi I work in the HR department of a large company, at present all of our disciplinary and grievance cases are stored on a very messy outdated excel...

What is the code and where should it be place to update a main form combo box after entering data into a subform combox?

I am new to using option groups. I will have several of them that will be a value of 1-5 and want to total them up in a report. Do I need a field for each...

I am using the DateDiff function in a report. I am using it based on 16 hours to caluclate process time of work. I need to include a 5 day work week. if a...

I'm looking for a Database that will allow me to store contact information and manage them, like the customer order database but also allows me to print...

I have weights for trucks recorded by date. For each TruckID I need to average the 3 most recent weights. So, I believe for each truck I need to query the...

In order to have accuracy when using decimals I was advised to use the currency type in a table. However, when I try to use the information I am getting...

I am using an unbound form to enter parameter criteria for my query. The command box draws records from a two column X three row table. Column 1 is the...

Hello All I need to create a new directory on my PC (under My DocumentsMembers) for each in table Members. Is there any way of doing this automatically,...

Hello, I want to crate a macro that prints just one record of one form linked to a table with 54 records, when I try to print the report the 54 records...

Hi From searching through the posts on sharing databases, I've determined there are two ways you can share a database. You can split it into front...

I have a query about colour coding the bars on a graph. I have values in a table I would like to convert into a chart. The values range from 1 to 10. What I...

Access 2007 / Vista 64 Professional Problem: If I doubleclick a table in the database 90% of the time Access locks up with "Access not responding". ...

Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...