Hi There, I'm having a problem with my Queries. I change my "DateIn" format to "Month([DateIn])" and returns 1,2,3...., but when I try to include a criteria...
Hi Neil, I got a question regarding your sample Secure database downloaded form your website. I have tried and applied according to your instruction given to...
Greetings! A new site of projects/bids has been opened recently: http://www.RainbowJ.com If you are owner of software company or freelancer this site may help...
Hi Will, Thanks, the procedure worked to give me a plain sheet form. Now I need to work on getting a header (letterhead info) on the form -- any suggestions? ...
Hello, friends! Do you need to develop software or website? Post your project for free and get quotes! If you are owner of software company or freelancer this...
Thanks for the help on the Date Problem. The new format keeps it in chronological order and the part in parenthesis makes the date easy to read. Another...
Nevermind. It was because there wasn't a format picked. When I made the format standard, the problem fixed itself. ... From: Becker, Jeremy S. Sent: Monday,...
Change the format property possibly to something like FIXED. "Becker, Jeremy S." <jeremy.becker@...> wrote: Thanks for the help on the Date Problem....
Good Morning AD.... Some basic questions: 1) Can you explain the "back slash" in the mask-value 2) Can you explain the ";0" in the mask-value 3) So my...
Hello, group. I am Eduardo and I'm looking for a bit of help regarding Access 2000. I have no Access experience and very little about databases in general,...
I'm setting up a form based on a query to search for a name or class for a training program. Although this method worked in 97 access, I cannot figure why I...
Sandra, Item-wise clarification on the points raised by you, is given below - 1) Backslash (\) when used as a part of input mask, causes the character that...
Hi AD, a) I really appreciate you explanation.....very helpful....will file away..... b) Followed your advice, (included your explanation as vba comments) to...
Fran: I'm recovering from a replaced hard drive, so I'm working from memory (notoriously unreliable for me!) When you open up a blank form you'll see three...
Such people don't have any idea of netiquette. They don't care if it is appropriate for this list or not. They will still cross post such messages on these ...
You are most welcome Sandra! I agree with the modified code finally adopted by you. Main reason for using the current event as suggested earlier was to display...
The moderator/list owner (assuming he/she is active) can ban them. Will owner of 4 lists ... From: Amit Rami <amitrami3@...> Sent: Jan 3, 2005 11:33 PM ...
Arnold, Could you please post the query in question ? A.D.Tejpal ... From: arnold choo To: ms_access@yahoogroups.com Sent: Monday, January 03, 2005 06:23 ...
I have a little database on NASCAR racing and am trying to show the number of consecutive races a driver has started in his/her career. I have a driver table...
Dear friends, i have a data of the customers with monthly payments i want to get the max payment column.. the table is like this: the table goes up to month 18...
Tufan, Im an access novice, but I'm pretty sure that reports are a good way to generate max values per customer. You may want to wait for better advice from...
In my crosstab query, where the date (by month) is the column heading. I want there to be a way where it only shows the dates that are greater than or equal to...
Tufan, You wish to compute the maximum of values across the columns, for each record. This is covered in my sample db named ComputeAcrossFields, available at...
Becker, The following course of action is suggested. PDate is the name of field holding the dates (such fields are not to be named as Date - to prevent...
OK I am back and still working on automatically loading data from a text file to an Access database. I have created a small VB app that runs and every minute...
Hi A.D., I did not realize that if I just type in 1 character into the combo box below and tab away from it that: Access will generate its own error message: ...
Hi all. I'm hoping that someone will be able to help please. I have not used MS Access much and am trying to make a database. What I am doing is I have a list...
can u send the code/logic of the vb app that runs every minute? Thanks ... ===== Charles W. Reed GOD's POWER IS AWESOME! __________________________________ Do...
Hi Tejpal, I have attached the sample database. Please try to run the "MyDateSearch1" (where the input is in number); and "MyDateSearch2" where I think the...