I apologize Steve, but my name isn't Doug either. My quote comes from Douglass Adams, the author of The Hitchikers Guide to the Galaxy.
I will putter with that over the weekend, but it looks simple enough.
Thanks again for your help.
Bill Lyle
I love deadlines. I especially like the...
Thanks Doug
I did check to make sure I was using the name property in the code for each control. That is why I was confused as to why it doesn't work.
There are about 35 controls on the form. Could you tell me a bit more about the about the generic function?
Thank you again for your help.
I...
I am working on a data entry form where many of the fields remain the same. I am looking to capture the value entered in each field and use that for the default value when I go to a new record.
I have the following code:
Private Sub Comments_AfterUpdate()
'declares a variable that will be...
COPY THE DATA FROM EACH TABLE.
THEN USE THE PASTE APPEND FUNCTION
I love deadlines. I especially like the wooshing sound they make as they fly by.
-Douglas Adams
I looked at some general USB pinout diagrams and pins 1 and 5 should be +5V I should be able to find it with a volt meter.
Thank you zepper for your help.
I love deadlines. I especially like the wooshing sound they make as they fly by.
-Douglas Adams
Thank you for your help.
I had very incomplete information from the guy I was helping. He needs to know the location of Pin 1 for the usb connector. I have a diagram of the board, but it doesn't locate pin 1. There is no indication visible on the board itself.
I love deadlines. I especially...
I am looking for drivers for a biostar 8500TUC-A does anyone know where I can find them?
I love deadlines. I especially like the wooshing sound they make as they fly by.
-Douglas Adams
I have built a prototype that I will be incorperating into my programs.
I have a user table which contains:
UserID
UserName
Password
PasswordDate
(For a little added security the user table is named MSysUsers. This effectively hides it from the average user.)
When a user logs in successfully...
My original thought had been to create a login form that would remain hidden once a valid username and password had been entered. I am glad that will work.
Thank you for your help.
I am trying to find a way to secure a database in access 97 to a greater extent than the built in security features allow.
My basic thought is to make a table with the following fields: [UserName],[Password],[UserLevel]
The idea is that the user would enter their username and password into a...
I have to calculate system down time for a helpdesk application that I am designing. The down time will be the number of business hours between when the system went down and when service was restored.
I have the following information to start with:
DateSysDn
TimeSysDn
DateSysUp
TimeSysUp...
I have to calculate system down time for a helpdesk application that I am designing. The down time will be the number of business hours between when the system went down and when service was restored.
I have the following information to start with:
DateSysDn
TimeSysDn
DateSysUp
TimeSysUp...
I did a similar thing when building a form letter.
My customer table had the following fields:
FName, LName, Address, City, State, Zip
In query design view for the query on which my letter was based, I entered the following into the Field box:
Address: [tblCust]![FName] & " " &...
Another Possible Help...
I have run into this problem before. Where forms especially, take a very long time to load.
Check to see if your application is saved in a fully compiled state.
to do this go to the code screen and in the debug menu look to see if the compile and save option is...
Create a text Box on your form
In the Data Properties for that text box set the default value to: Time()
Then go to the event tab and choose: On Got Focus
Click Build and choose macro
In the macro choose SetValue
In the Item field enter the name of the text box
In the expression field...
Try this in the criteria field
>=[Enter Start Date]
I have used this setup and it has always worked for me.
If that is not it look at how you are calling the query. For instance if you are using a command button to open the query and then to open a form based on the query eliminate the run...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.