pgirl
Last Activity: Jul 5 '07, 07:30 AM
Joined: Oct 2 '06
Location:
-
You may have another Expr1 - it's just a named expression. You can go into design view in the query and call it anything you like. Try renaming it. -
Can you post the update query or code you are running at the moment please?Leave a comment:
-
Here's one way you could do it.
1. Create a query - let's say you call it qryEvents.
Add all the fields you want to display.
Let's say the date for the "event" is stored in event_date field. Add another two fields - Call one
Expr1: Month([event_date])
and the other
Expr2: Year([event_date])
This will extract the month and date for the event.
The...Leave a comment:
-
I have solved this problem!
Kaspersky Antivirus macro blocker was stopping Access from running correctly. No error messages were being displayed, it was just blocking the inbuilt macros from running.
I disabled the realtime macro checker and it immediately fixed the problem. All fields are now displayed.Leave a comment:
-
Have you thought about using something like http://www.aweber.com/ ?Leave a comment:
-
So your form shows one record at a time - sorted according to the primary key.
You want to click a button and have the form display one record at a time starting with the lowest ref_no?Leave a comment:
-
Create a new mdb database.
Use the file -> get external data -> import utility.
Choose SELECT ALL to import all the tables, queries, reports etc.
You can import the data as well, or just the data definitions. (Click OPTIONS to choose)
This should give you back the design options.Leave a comment:
-
If you are running Access 2002 or 2003 you can convert the database by
tools -> database utilities -> convert database -> to access 2002-2003 file format.
You will have to choose a new database name.
Then close existing database, and open converted one.
Then choose tools -> database utilities -> make mde file again
Hope this helps.Leave a comment:
-
Or click on File -> Export and choose csv from the file types list.
You can click on the ADVANCED button to set more options.
This will put each record on a new line and seperate each field value with a comma.Leave a comment:
-
You can use WebBrowser activex object available in controls.Leave a comment:
-
Tools -> Database Utilities -> Make MDE fileLeave a comment:
-
It seems like you have a many to many situation. Why don't you create a new table called tblDateCallsign with a unique datecallsignid as the primary key then put the callsigns in one table, the daily attendance info in the other and then the callsign_id and date_id and lookup each of the names in the middle table.
You can then produce a query or a report that joins the three tables and lists all names against a certain date.
...Leave a comment:
-
Available Fields Blank
I've never seen this before.
I went to my sister's to have a look at a MS Access (XP) problem. She's created tables with data but when she tries to create a query, form or report using the wizards, the table names appear in the drop down box - but the available fields listbox is blank - for every table.
Creating a query in design view shows all the fields.
When I created a new blank database and added...
No activity results to display
Leave a comment: