erniemack
Last Activity: Jan 27 '11, 09:35 PM
Joined: Mar 4 '10
Location:
-
using comdlg32.dll in my access 2010 prog how to set default path
Using comdlg32.dll to allow the user to reference a .jpg or .bmp file I want to have the default search to be the current folder plus \images. How can I pass that info to comdlg32.dll? -
Thanks very much. It is hard for me to wrap myself around some of this code when I try it myself. I understand what you sent tho. I have been programming since 1965 using basic, NCR Neat/3 and a db language that you have probably never heard of TAS. Some of the pictures are coming into focus thanks to people like you! -
This I know. Why will it not compile and how would I code a lookup to check a user name and password. To my old timer way of thinking you would have the user key in an id and password then look up that user's record in a table and check to see if the typed password matches the one in the table. You would then be able to use other info in the table to determine what access to give this user.
ThanksLeave a comment:
-
Select statement
Ok I am an old time programmer but I can not understand why I get a compile error on the following statement. I am using access 2003
SELECT tblUser.User FROM tblUser
I have a form where I want the user to type an ID and Password then upon exiting the password I want to check a table to be sure the combination is there and also assign a level of security based upon a third field in the table. The table contains:... -
I used
DoCmd.OpenForm stDocName, , , "[jobnumber] = " & acct
It worked. Thanks for the responseLeave a comment:
-
Thanks that works like a champ!!!Leave a comment:
-
use combobox lookup value on one form to populate another form
I have a form with a combobox using the following query:
The bound column is column 1Code:SELECT JobNumber, CustomerName, [PO], [Customer Motor #], assm_status FROM tblJob WHERE assm_status<>"Done" ORDER BY CustomerName;
...Code:Private Sub CustomerSearch_AfterUpdate() On Error GoTo Err_customersearch_Click Dim stDocName As -
Change form and display record from previous form
I am using a combobox lookup on one form and would like to use the value returned from that lookup to display a record on another form. Here is the select statement:
SELECT tblJob.JobNumbe r, tblJob.Customer Name, tblJob.PO, tblJob.[Customer Motor #], tblJob.assm_sta tus FROM tblJob WHERE (((tblJob.assm_ status)<>"Done" )) ORDER BY tblJob.Customer Name;
Column 1 is the bound column
Here is the... -
Actually I found my own answer. In the criteria for the query in the desired field I used >now()+3Leave a comment:
-
erniemack started a topic access 2003 how do I use the difference between a date in the record and todayin Visual Basicaccess 2003 how do I use the difference between a date in the record and today
Hello I am an old programmer (since 1964) but new to access. I have a Job table that contains a "promise date". I want a query that will extract all records whose "promise date" is within 3 days of the current date. This has got to be simple but I am probably looking for something hard. Thanks in advance.
No activity results to display
Leave a comment: