Search results for query: *

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...

Thanks for the tips everyone. I'll try your suggestion out AceMan1 and post the results.

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.

That's what I'm afraid of...is there a way of timestamping a field with just the date only?

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...

Yay!! That was it. Thanks for you help. You da man.

Thanks. I tried that but nothing happens after I select Completed.

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...