Greetings,
I have a report that counts and displays records using a bar graph by month. Is it possible to display a bar graph by quarter (1Q, 2Q, 3Q, 4Q)? THanks
Greetings,
I have a report that shows where a person is ranked in terms of number of jobs done for 2005. I'm trying to figure out a way to display next to this year's rankings the ranking in the prior year. How can I go about doing this? Thanks.
Greetings,
How can I have a checkbox display on a form only when a specific record comes up. For instance if a user goes through records on a form and any John Smith record is displayed a checkbox will appear.
I seem to have found the culprit. I can export every object in the database except for a table. This table happens to be the one that stores all the important data too. I also tried importing it into a new database but it just hangs there on the last bar. I ran a performance check on it and...
Greetings,
I have a database that has been working fine up until the past few days. Now periodically I will get a message "This action will reset the current code in break mode", "Do you want to stop the running code?"
If I click yes the same message keeps popping up, if I hit no I return to...
I'm new to Macs and can't figure out this problem I am having. I recently installed Airport Express and that went fine. But everytime my powerbook boots up now the Airport Express Assistant opens automatically. How can I disable this? Thanks.
Thanks Blorf...whoops I realized I typed the wrong thing. I am using Now() and not Date(). I tried using date() but everytime I used it on the form Access would enter the date that the record was created and not when Completed is selected in the combobox.
Greetings,
I have a field on a form (ReviewStamp) that is timestamped Date() if Completed is selected in a combo box. However when I try to query for records using this field in the table, I get no results. I've tried creating a query using Date() for the criteria under the ReviewStamp field...
AceMan1,
I am trying to create a query for dates now but I can't get results. For criteria I am used Date() under the ReviewStamp field but nothing comes up when I run it. I also tried entering a specific date such as 10/20/2004 but I don't get results either. I would like for someone to...
Thanks for all your help AceMan!!!
If I want to use a combobox to timestamp the textbox field how can I go about doing this? For instance I have a combobox that has a status of Completed and Assigned. If Completed is selected the textbox will be timestamped. Thanks again for your assistance.
Thank you both for your replies. Unfortunately I inherited the database with this table so I'm trying to find a way to get out of this bind. I'm about 4000 records deep and all the records are in this format. The reason I would like the tables sorted is because when I run a query the results...
Greetings,
I have a table that have entries labeled alphabetically and numerically (ie: AP04001, AP04002, AP04003). The "AP" will always stay the same, "04" is for the current year, and the last three numbers correspond to the entry number. I am having a problem when it comes to anything over...
Thanks AceMan1!!
I added the field ReviewStamp to the recordsource table and added the field to the form. I added the code in the AfterUpdate event (substituting names). However when I try the form out by clicking on the checkbox nothing appears in the ReviewStamp field. Help!!
Greetings,
I have a job form that contains a checkbox. The checkbox is for whether or not a particular job has been reviewed. Is it possible to add a textbox next the checkbox to show when the record was reviewed (timestamp)? If so how do I go about doing this?
Basically I would like to be...
Greetings,
I have a form which displays data from a job table. If I try to print the current record I am looking at it prints all records. How can I prevent this and how can I print just the current form? Thanks.
Thanks for the reply. I have two tables (tblClients and tblJobs). tblClients contain client info such as CliName, CliAddress, etc. tblJobs has JobNo and DueDate.
The query I have for the report counts the JobNo using DueDate as a parameter. Criteria for the DueDate is:
>=01/01/04 and...
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.