Search results

Hello, I tried to import a csv file that I will be receiving on a regular basis to add to a table in ACCESS. One field has date/time that has the format "5/26/2008 00:00:00" in the .csv file. Unfortunately, when I import the CSV file, this field that has the date/time format does not...

Hello there, I am making a roster for 25 people. In my form, the start of the roster is 0700hours until 1900 hours (increments of 15 minutes each) so I have 48 check boxes, which are ticked when one is rostered on for that time. I am getting crossed eyed looking across the screen at these 48...

Hello there, I have a form that has a comand button to exit the form and ACCESS. I accidentally clicked on a blank area on the form and the database closed and quit ACCESS. I tried again to see if clicking anywhere the form (not on a control) would result to the same thing and it did. Can...

Hello, I have not used my small knowledge of ACCESS for a while. Could someone please help me with this. I have a form that needs at least 4 four-sentence paragraph to be inserted to a form when a button is clicked. For example: button 1 when clicked would populate a text box with the...

Hello, I have a table wherein the time worked by 25 employees are recorded. This table has the start time, endtime, break time and late times. The Late Time is the number of minutes that the employee is late to work. I am required to do a query of the team's (all 25 staff) late times per...

I have form with an option group (to select a gender) which is as follows: Option 1 = Male Option 2 = Female After choosing on an option, a command button with the caption REGISTER is clicked. A macro is attached to the command button with conditions as follows...

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

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

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

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

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

I have to columns, one showing the total minutes a worker is entitled for breaks and another column for the total breaks actually taken. I ran a query to calculate the extra breaks taken. Some workers took more than the planned break time and should have shown negative numbers, but my query did...

Hello, I have a a main form with 3 subforms in it plus a list box. All 3 subforms are synchronised with each other and I would like the list box to be as well. How do I do this please? I am desperate for an answer. Thank you. Ligaya

How to write macro to stop a form from closing and exiting ACCESS. I have a message box that asks "do you want to save and exit now?. There are yes, no and cancel boxes and when any of the boxes is clicked, the form closes and exits ACCESS. I would like the form to close only when yes is clicked.