Search results

Import date format "MM/DD/YYYY hh:mm:ss from CSV Hello! Changing the format of the date/time to text worked. Thank you. Regards, Ligaya

Impot date format "MM/DD/YY hh:mm:ss" from CSV To The Mailman, Hello there, sir. I have already tried previously what you have just suggested without much luck. What I neglected to mentions is that the date time(for a start time) has AM or PM after the time, for example: 5/26/2008 7:30:15...

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

Yes/No Boxes Hello Pat, Gemma and Chris, Thank you for your thoughts and suggestions. I am out of the office for a few days and will not be able to try out what you've all mentioned until I get back. It sounds challenging and it would be very interesting to see the outcome and presentation...

Yes/No Boxes in 2 Rows Many thanks, everyone for your input. I was following instructions from my superior to do a roster with all the 15 minute intervals, hence the 240 check boxes. This is going to be used in calculatiing how many employees are required to work at certain periods. I...

Hi, Thanks for the quick response. I have 240 fields :48 for each work day - Monday to Friday (5 work days) and my form is continuous. I do not have much experience in other forms. Regards, Ligaya

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 Moniker, Further to my email earlier, you are absolutely correct in your diagnosis. I found that I had accidentally entered the code on both the exit button's On Click event and on the detail's On Click event. Thank you ever so much for your help. Now I can retire for the night...

Hello Moniker, Thank you for the prompt reply. I deleted the exit button and put another command button in its place and made certain that the code was on the OnClick event of the button and tried it out. I double clicked anywhere on the form and I exited ACCESS, so I am back to square one...

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

populate a form with text... Hello Chris, I really appreciate your input and I shall try it out when I go back to work. Thank you so much for your help. Regards, Ligaya

Yes, it is!, thank you very much, Chris! When the report is printed, only the comments will show in the report, is that correct? But I tried and copied what you sent to no avail. I am feeling frustrated that I cannot make it work. My brain cells have certainly atrophied. Regards, Ligaya

Hello Chris, Thank you for your prompt reply. Unfortunately, I tried it and got nowhere. I will try it again and who knows, something might click in my brain and I will get it going. Thank you again. Regards, Ligaya

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

'Total hours (or minutes) in a query'‏ Hello Neil, That's something I have not done before, so I shall certainly give it a go. Thank you. Regards, Ligaya

Hello Dennisk and Brianwarnock, Many thanks to you both for your replies. My brain cells have atrophied and hopefully will regenerate in the morning when I shall do what you have suggested. I appreciate your input since I've been floundering so terribly, trying to do the totals for the team...

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

Type mismatch in Macros Hello Ken, Thank you for responding so quickly. I'm still grappling with it. I tried and got a Run-time error '424': Object Required. I don't know what this means so I will look it up and will try again. Thanks again. Regards, Ligaya

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

Guus, thank you for your input. I appreciate it. Regards, Ligaya