Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Aug 1, 2005 7:33 am
28612
AJ, Sample db named PumpUseStatus_2K.zip, uploaded to files section of this group, might be of further assistance. It demonstrates generation of following...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Aug 1, 2005 10:30 am
28614
Mr. Viescas, I did the modification that you wrote down, and came out that the bldg number doesn’t get saved on the appropriate filed on the table. The code...
You are trying to make the combo box control "serve two masters." You can either: 1) Give the control a Control Source (make it "bound") so that it updates ...
I'd like to have a calendar database that I can enter employees vacation and other leave requests and be able to print out a report showing who is on leave on...
Jim- You just need to fix your query. I bet you asked for all records that are entirely within the timespan. To ask for all records that cross any part of ...
Hi guy's, I am trying to get a phone number field to insert the "406" area code if the user does not supply it. I can do it just fine if I remove the input...
Thank you for clarifying this with me. So I’m going to add one more filed, control source for Bldg. no. and also I will make Bldg. No as primary key as it is...
Neil- What happens if you set up an input mask? If you want to store just the numbers, you should set up the mask to not include the pattern characters in the...
I fixed it like this SELECT employees.*, LeaveTime.*, [End Date]-[start Date] AS days FROM employees LEFT JOIN LeaveTime ON employees.ID = LeaveTime.EmployeeID...
Ok, this seems to work, but I'll test it some more. SELECT employees.*, LeaveTime.*, [End Date]-[start Date] AS days FROM employees LEFT JOIN LeaveTime ON...
Jim, As John pointed out previously, all you need to do is compare the leave start date to the range end date and compare the leave ending date to the leave...
Jim- It will work if you do exactly as I suggested. Try this: PARAMETERS [Start Date?] DateTime, [End Date?] DateTime; SELECT employees.*, LeaveTime.*, [End...
Jim- You have made it more complex than necessary. See my earlier reply. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office...
Yup, that works fine. I mixed up the start and end dates in mine and got them backwards. That is why I ended up making it more complex than it needed to be...
Hi everybody, thanks in advance for your help! I have a table in Access with a number of fields in it, most importantly [TravelOrderNum], [DepartDate], and...
Bill, when trying to run the below code, I get the following error, Compile Error: Can't Find project or library. At that point, it highlights Chr. In this...
CJ This gets a recordset of all the pairs ordered by travelordernum and DepartDate. It assigns Outbound to the first one and Homebound to the second one. ...
Joe When Access gives you an error message like that for a built-in function, it usually means you have a missing reference. In the code window, click on...
Hi Bill, Sitting at home (in Sweden) and just tried on a small sample and it seems to working perfectly, THANKS!. Will try on larger scale tomorrow when in...
Danny, Thanks for suggesting this. So far I had not gotten DMax to work (probably because of nulls), but I had not looked at domain aggregates at all. They...
Ah, of course. Thanks, John. There actually is a table already there (tblFactorsPump) that has the pump numbers listed, along with the KW factor and the...
AD, Thank you very much. So far, I've gotten permission to download your file and obtained WinZip. The database has been extracted and I've had a fast look...
Group, I have MS Access 2K. I would like to know if anyone here has developed a progress meter that is embedded in a form. For example, I have a macro that...
Isaiah- There's a Progress Bar ActiveX control - but you might need the Developer's edition to get that. And you'll need to learn VB, not use macros. You ...
Thank you John! Thanks, Isaiah Vi Information Technology Analyst County of San Mateo Human Services Agency Business Systems Group 400 Harbor Boulevard,...
I haven't started using it yet. I've been trying to decide whether to learn VBA or go directly to VB Net. I just wanted to make sure I wasn't doing something...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
