Hi,
I have this question regarding autoincrement. I know Access already has an autoincrement option for a number field but the problem is that if I delete a record then when you add another...
I have packaged my progamme with Microsoft Office Access Developers Extensions. When opened by the user a message appears that the "project contains missing or broken reference to the file mso...
What's the best way to find out how many records in a query via VBA?
How can I recover file powerpoint? I've set the autosave to one minute, but when I reopen the file from previous hang, it won't show the update to the file.
I'm just working with this MS Access application someone else built a long time ago and I'm a bit confused. There is a form which has two text boxes, and somehow when something is entered in t...
Hi
How can i get Access 2007 to open a form automatically when i start it?
Many thanks in advance
Christos
Do any of our experts know where I can get a database table with a list of all UK towns, cities, counties and postcodes for checking the missing information in my existing database.
Many th...
I have two Access database, db1 and db2. Both has an exactly same table, [Table1]. I like to update value in [Table1] in db1 and automatically update value in [Table1] in db2. Is it possibl...
Access 2003 and 2007 Differences
When I enter the expression below in the field of a query I get the message "Undefined function TRUNC in expression" - can someone tell me what I'm doing wrong.
[%VAT] is the name of an exp...
Hi guys 'n gals,
What's the SQL Syntax to display a list of the Column Names in a specified Table?
Cheers!
I am trying to find a simple way to merge data that resides in two diferent acess tables that reside in one master database.
Table 1 has first name, last name, address
I need to get this...
Hi,
I have two tables. [TblProject] is set up with the following fields:
ProjectID (AutoNumber)
ProjectName (Text)
ActiveProject (Yes/No)
and this table has a one to many relationship...
Do I have an ability to use swith/case statements in Access 97
Hello:
My mission is to add images to each record in a database. These images are unique for each record. This is easy to do manually but for 2000+ records, manual is not an option.
I ...
I have the Microsoft office package for MAC. I need to be able to open files with a .snp extension. I keep finding comments that this is not possible, but the comments are all a couple of ye...
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,
I've encountered a problem at one of our clients that involves putting users and passwords into an access database using the user and permissions wizard. Our client wants a total of about...
EE Experts,
I have made a best effort to research a solution to my problem without success. All the solutions that I have found here on EE and elsewhere just don't fit my situation exactly....
I'm looking a command to use in the Criteria of a Date field in an Access query to select the previous month. The command below works except for in January. Any ideas?
Month(Now())-1
HI. I have a fairly simple problem that i cant work out. I have not slept in 2 days so i think my brain has stopped functining.
I have 2 tables
table 1, table 2
each table contains an Ac...
I have a table that has a recordsource with 3 tables in it. This form has a button on it and the button creates records in another table. I am having a problem searching through the recordset ...
Hello,
I am having trouble with my Access query. I have a field that I would like to filter out by certain letters in that field.
This field is called Notes.
Each query will output about...
Basically I want to the query to split comma delimited values into separate columns in access query
example:
Apple 1,4,5,6
Apple 1 | 4 | 5 | 6
How would I do this?
I have an MS Access application where I send an email out to a customer using Vba code. I use DoCmd.SendObject to email a customer the information.
Everytime I send out an email I get a ...
