Search results for query: *

Question 1: I have reservation database in access 2007 I have a cabin information table with: cabinid (primarykey) cabinname(text) cabinlocation(text) I have a customer table with: customer id(primary key) last name (text) first name (text) address(text) I have a reservation table with...

I am trying to create a form that a user can input start time/stop time, then intervals in minutes that will update a table with the results. Example: User inputs start time 9:00 AM and stop time of 10:00 AM with 15 minute intervals. The table would then contain 9:00 AM 9:15 AM 9:30 AM 9:45 AM...

I have a query in Access 2002 that outputs to excel.In the query is a field called date. Is it possible to change the format of the date field in the query when it outputs into excel but not affect the database format? The problem is that I don't want the query to output the date field in the...

I have a query in MS Access 2002 that outputs to excel. In access I created a module that rounds and truncates numbers to the nearest tenth in an after update event on a form. Example: 1.45559999 will round up to 1.5 and truncate off anything else. When I pull the query into an excel...

Hi. I have the following tables. Employee employeeid-autonumber primary key Name- text Projects Projectid-autonumber primary key projectname- text projectdescription-text Boxes boxid-autonumber primary key boxname-test boxdescription-text projectid-lookup to project Worklog...

Hi. Access 2002 Question here. Here goes... I have a form based on a single table that a user inputs a log of projects that are being worked on. Fields are as follows: Date (DD-MM-YY format) Start time (HH-MM-AM/PM format) Stop time (HH-MM-AM/PM format) Project (TEXT Format)) Hours (Number...

I have several worksheets that calculate hours worked. On each worksheet there are the following cells: Date Start time Stop time time Hours worked (I already have the hours cells calculating time between start and stop times) I would like to have 3 cells at the top of each worksheet that the...

I would like to assign a funtion key to Windows (let's say F10) that performs the following operation ALT+TAB+Space Is this possible?

I have a cell that is formatted as time of H:MM AM/PM with a data validation of Time and the validation set from 12:00 AM to 11:59 PM so the user has to enter the time exactly that way. The problem is that if the user enters the time without the AM or PM like 2:00 and not 2:00 PM the cell...

I have a workbook with several worksheets in Excel 2002. How do I create a windows Shortcut to point directly to a specific worksheet. Excel would then open directly to that worksheet.

I have a worksheet in Excel 2002 that has 3 cells- Time in, Time out, and hours worked. The hours worked cell calculates from the Time in and Time out cells. I then protected the sheet and locked the hours worked cell. Now Excel crashes after I update the Time out cell. When I unlock the hours...

EXCEL VER 2002 I have a column in my worksheet(worksheet1) that has project abbreviations in the cells. The cells are named as Projects and another worksheet(worksheet2)uses a data validation list that uses the list to select a project abbreviation (just a regular old list, nothing special)...

I have a timesheet worksheet that has a time in column and time out column and hours worked column The time in column and the time out column has the cells formatted as time HH:MM AM/PM The hours column has the cells formatted as number (2 decimal places). I need to auto calculate the...

I have a subform with the following fields Time in - format as short time (12:00 AM) Time out - format as short time (12:00 AM) Hours - format as a number (2 decimal places) I need to calculate the difference between Time in and Time out and then populate the Hours field after the user updates...

I have a subform with the following fields Time in - format as short time (12:00 AM) Time out - format as short time (12:00 AM) Hours - format as a number (2 decimal places) I need to calculate the difference between Time in and Time out and then populate the Hours field after the user updates...

I have a form/subform linked by account number. My main form(customers) has these fields: ACCOUNT(primary key) CUSTOMER(text) ADDRESS(text) My subform (trouble tickets) has these fields: TICKETNUMBER(primary key) ACCOUNT(linked to main form) TROUBLE(memo) DATE(short date) CALLTIME(number)(user...

Access 2000 or 2002 I am creating a photo gallery database that stores the name of each person and a link to each photo they have. What I would like is for access to automatically create a new windows folder with the persons name as the folder name every time a new person is added. Is this...

Hi. What I would like is a user login/id from within the database (im assuming at database startup) that does not rely on the access user security features.I dont really need security, I just need to log who updated what records.

Access 2000 Form Question Hi gang, heres my situation and problemo. I have tons of paper docs and have to scan them into the computer for use in my database. Once scanned, I need to use the scanned docs to enter info (with digital ink)on them for printing and electronic storage. 1)I scan the...

I have a form with a field on it of [emailaddress]. I created a command button that when clicked opens email and puts in the email address in the to line. Heres the code. Docmd.SendObject acSendNoObject,,acFormatRTF,Me![EmailAddress],,,,,-1 The problem is when someone clicks the command button...