I have a date field and i want to add days to it in a query or report. I have a database that keeps track of people and dates for training and they need to be trained every so often. i want a...
Hi all,
I'm trying to get "Regular Expressions" to work in MS Access. I am relatively new to "RegExp" and have been reading up on it in experts exchange. I've created a module in Access and...
I have an Access 2003 Database in which I would like to run a query to change the default values for several columns within a table to NULL. Is it possible to write a query without VBA to do s...
I'm looking for advantages that SQL Server has over MS Access. Mainly, what are the reasons that an SQL server is a better way to store and run databases from, rather than MS Access. Also, if ...
In an Access 2003, I've got a MainForm with a SubForm. The subform is based on a query, which is itself based on a query & a table. In the subform, the user enters an InvoiceID and VendorName...
How do I alter a table to allow null values in an Access database. The application is ASP.NET and I want (=need) to use standard SQL DDL that *must* also work with SQL Server and avoid Access...
I need to import data from one Microsoft Access database to another, preferrably using a single SQL query within a C# program. For the particular data I'm working with, it would not be useful...
Experts,
I am trying to run the following update this update statement works:
UPDATE MJM_ATTEND_PAY_INDIV SET MJM_ATTEND_PAY_INDIV.ATTEND_PER_MONTH = 4
WHERE (((MJM_ATTEND_PAY_INDIV.ROW_I...
Not sure how to solve this.... I've been searching solutions here and getting more confused...
I am trying to append a record to an attached table whose primary key is an autonumber. I ge...
I am using VBA code to compare dates the line of code that I am using is:
If Format(PStart, "mm/dd/yy") >= Format("7/1/68", "mm/dd/yy") Then
PStart is a specific date field with dates like...
I have an Access 2003 database and I want all text to be entered to be in capital letters. I know I can put UCase in a query but is there some way that in the tables it just automatically goes...
Hi
How do you NOT show the recordset as a result of this:
DoCmd.SetWarnings False
DoCmd.OpenQuery "qRev3a"
DoCmd.SetWarnings True
I do not want the table/recordset show up
...
When I use a SELECT DISTINCT query.
Eg SELECT DISTINCT Organisation FROM TBL_Orgs.
How do I select another another field but still keep the Organisation field distinct.
When I us...
Say I have a table like the one below in MS Access:
tblPay
Payer claim percent
tom 100 10
jerry 200 20
tim 230 5
I'd like to co...
I'm trying to setup a database for toners/ink cartridges. The table (inventory) I'm using have 3 field. When I get new toners/ink cartridges in, I will scan the barcode and it will update th...
I have 2 databases; one called Employee1 and the other Employee2.
They both contain the same fields: FirstName, LastName, EmailAddress, and Center
The same record might exist in both databas...
I am having a hassle with an ACCESS app that a colleague developed to extract data from a Foxbase database. The hassle that I am having is that all of a sudden after literally years of workin...
I have a table that contains a customers details and 2 addresses (all in 1 table). The 1st address is a home address and the 2nd a business address.
I have a form based on this table. The ...
I have been tasked with creating a report in MS Access and creating an identical report in MS Excel.
I had no trouble creating/formatting the MS Access report but "exporting" it to Excel pr...
I have two subforms that I am trying to synchronize and it's not happening. I am wondering if you could help please.
Subform 1 is called frmCampaignsSub (continuous form)
Subform 2 is call...
Hi guys 'n gals,
What's the SQL Syntax to display a list of the Column Names in a specified Table?
Cheers!
I need some help asap, if possible...
I am working on creating queries to output data into excel files. The query provides multiple groups of data (all numbers). I need to be able to provid...
Hi,
I would really appreciate it if somebody could run me through how to use Union Queries.
I'm totally new to union queries and don't have a clue where to start.
I would love it somebo...
I'm looking at solutions to send HTML-formatted emails via MS Access.
I do not have Outlook reference but do have access to an SMTP server.
Is there a way of doing this? If so, could you...
Hi all,
I think this is easy...Is't possible to insert a new record using values from another record(using a subquery) AND values i want to insert (using the VALUES clause)? Or do I have to r...
