Search results

Suppress closed records on a form Many thanks for your suggestion, Ray. I shall give it a go. Regards, Ligaya

Hello, I am at my wit's end and cannot seem to find a solution to the problem. I have a form which is used for entering data on issues and problems in my work. When the issue or problem has been resolved, we click on a "closed" radio button. There are no scroll bars or navigation bars on the...

crosstab report Helll lark Tilly, Thank you for not giving up on me. Unfortunately, the db is on the system at work and cannot be copied. Again, thank you for taking time to help. Regards, Ligaya

Print Start Date an End Date on Title Page of Report Success! Thanks for your help, Ray. All's fine now. Regards, Ligaya

crosstab report Hello lark Tilly, No joy! I have no experience with VB; have followed your instructions diligently. The red dot did appear, but no line was highlighted in yellow. No value showed up showed up either for the months that I know for sure have numbers in them. I am very...

Print the Start and End dates on title page of a report Hello Ray, Thank you for your assistance. I shall certainly do as you suggested. Regards, Ligaya

Date Range to show on report Hello Ray, All the dates worked by the employees are in a form, and I created a query with a criteria to pull out the data between a certain start date and end date. My report is based on the query. When I open the report, with the prompts, I type in the dates...

Hello, I have created a report which shows all the hours worked by employees over a week (between a date range). The report is like a timesheet. I would like to have the start date and end date of the working week to print on the title page of the report (e.g. Start Date 6/06/07, End Date...

Crosstab report I changed the fields to suit my name fields and no, there was no error message. When I ran the report, there was nothing in the page footer. I really don't know where I'd gone wrong.

Hello lark tilly, It's me again. I copied the code you had on the sample crosstab report and nothing happened. My report did not show the sum in the page footer. I cannot fathom where I went wrong. Any ideas? Regards, Ligaya

Hello lark tilly, Thank you for your help and the attached sample. I shall certainly try it out and apply to my own report. Regards, Ligaya

Hello, I have just created my first crosstab report. In it I have different types of activities done by an employee as the row headings, the column heading are the months of the year. Per month, I get a sum of the particular activity done (e.g - for month of May, answering the mail = 15, doing...

Title Page in ACCESS Report Many thanks, Bob. It worked like a breeze! Much appreciated. Regards, Ligaya

Hello, I have just created a report in ACCESS. I have a title page and I would like to know how to suppress the date and page number on the page footer in the report's title page. Could someone please asssit me? Many thanks! Ligaya

List box in a form Hello Wayne, Thank you for your reply. I shall try out your suggestion. Regards, Ligaya

Hello Bob, Thank you for your help. I shall do exactly that. Regards, Ligaya

Hello, I have a text box in an ACCESS form that is blank. How should I format it so that zeros are visible until a digit is entered into that field? This column is for ovetime figures (e.g. 1.35 hours) that will be entered later. I would greatly appreciate any suggestions and help. Regards...

Belated thank you to Chergh. Regards, Ligaya

converting hours to seconds Hello Neil, Thanks for answering. The 1.52 referred to one hour and fifty-two minutes. Regards, Ligaya

conversion hours/minutes to seconds in a query Hello again, If I have several rows in a column that is already in minutes, and a couple that has a combination of the hour and minutes (e.g. 1.52), how do I enter in the expression in the query to convert all into seconds? Please help. Thanks...