Bob,
The trick is to put two images on your form.
For instance, I have a form which allows the user to view a different image when clicked.
Enter this code on the On Click () Event and enter it in reverse for the other image.
imgOne.Visible = True
imgTwo.Visible = False
gormcd
Access automatically "saves" or commits a record when you move to a new record.
Refresh will also save data, since it commits the data, or requeries the data.
gormcd
Actually, I would suggest to use 0 Or Is Null as criteria for NO.
When you have not checked a check box, the contents of the table will be NULL.
If someone checks a check box and then unchecks it, the contents will be 0.
gormcd
I believe this may be what you are looking for...
Set defaults for the appearance of Datasheet view
1 Open a table, query, or form in Datasheet view.
2 Click Options on the Tools menu.
3 Click the Datasheet tab.
4 Click the options you want.
Note These options do not override any changes...
I would check the data. I have had a database do similar things because of corrupt data in just a few records.
The easiest way to check for this is to try to copy the contents of the table.
Do this by copying say a thousand records at a time. If it allows you to copy the first thousand, go...
Create a new query.
Add the two tables.
Join employee id if it is not already done.
Bring down employee ID from the holiday entitlement table.
In a new field enter the following:
HolidayLeft:[HolidayEntitlement]-[HolidayTaken]
If you have any questions, please let me know.
Thanks.
gormcd
It is commonly referred to as a "Pipe" it is used in many programming languages.
In UNIX, you can concatenate commands using the Pipe.
It can also separate fields in other data. Most of our raw data comes to us using the Pipe as a field separator.
gormcd
We have an Access 97 database in a Windows 2000 environment. The database closes on its own.
This never occurred when we were running Windows 95.
Do you have any idea on how to fix this?
Thanks for your help.
gormcd
s-)
I have a report in which I need to show month to date and year to date totals for turnover analysis.
The report is grouped by Department #, Job Code # and lists the new hires. They needed the count of people who were hired hired split out by work status (Full-time, Part-time, PRN, Per-Diem...
I have a crosstab query in which I am trying to use the Nz function with no success.
Here's what I have:
Field -- The Value:Nz([WorkStatus])
Table -- BLANK
Total -- Count
Crosstab -- Value
Or... in SQL View:
TRANSFORM Count(Nz([WorkStatus])) AS [The Value]
SELECT qryNewHires.DeptNumber...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.