Search results

I have an input box that asks for a password how can I set it up so that the characters that the user types in will appear as *******s rather than the actual characters typed?

Thankyou Kindly.. That was exactly the problem! Cheers!

I am trying to email a report using DoCmd.SendObject. but every time I try to run the code the internet connection wizard keeps coming up. My email account is in place. I need this application to use the users default e-mail account to send the message since the data base will be on a...

how come I can't change the subject line of my thread on the >General page of this forum.... I would like to change it so it says **RESOLVED**blah,blah ....

never mind........ the problem was... I'm an idiot! I must have saved the data base as Service.dbl.mdb somehow and my file list was not showing "Known Extensions" so ithought it was .dbl Not Thinking. It works fine sorry to waste yer Time. cheers

my database is saved as .dbl I'm not sure why though.....it opens fine when using access. maybe this is why it wont open from hyperlink....?

**RESOLVED**linking to DB with html I want to put a link on a web -page that will open an access database....This is on an intranet environment...and security for the database is not a major concern. I tried it like this ----HTML-----snippit------------------------ <a href...

Yes, Indeed Thankyou. Marvelous how that works isn't it. I am only using C now. How about making all the records in qryMissedEntriesC show up in a message box. Right now I have it so the dynaset shows up on the screen, but I would rather have a message box that contains the names of the...

ty thanks again

I have a timecard database and I am running a series of queries that determine if entries have been missed for any individual(s). The first query determines who should have entries the second query determines what entries have been made the third is a mismatch query that determines who has been...

thanks for the help, I have the queries opening the way they should...great. I have been turning to the help files. But I have been finding that the syntax examples are hard to follow. They get me close but then I have to trial and error for awhile until it works! Your explanation will...

I am having a hard time figuring out when to use [] and whent to use () and when you don't need any brackets. I am trying to open the following queries when a cmd button is clicked. Do I have to Dim the queries as strings and call them from their variable name? DoCmd.OpenQuery...

I am using Access 97 and the ! format only seems to force left justification on number fields...it does not seem to reverse default justification on text fields. I have no problem getting right justification when viewing the data using access....it is after the data is exported to text that the...

Wow, this .txt export is causing me a whole lotta grief....I mean Wow, what a great learning experience. I am using a query to export to a text file. the field I am having trouble with is a text field and it needs to be right justified. The justification is correct for the query, and the...

thanks, I finally got it to work....had to use another query with the formatting thanks for all the help.

thanks! But now another question.. what is s the best way to convert the field to string. I tried making another query based on the old query that used@@@@@ as the "hours" field format but the dynaset for the new query is dropping the leading zeros

Should I convert the field to a string rather than a number? .txt files don't know the difference between numbers and strings...right?

I need to preserve leading zeros in a field when I export a table to txt. The "hours" field needs to contain 5 digits for example 40 hours should look like 04000. I am using a query for the export, the dynaset for the query contains the right amount of zeros but when the export is performed I...

help with leading zeros I am trying to export a query to text. The hours field needs to contain 5 bytes, for instance 40 hrs should look like 04000 I can get my dynaset to look like this but when I export to a text file I lose the leading zeros. I have tried to follow the advice I found...

never mind, I think I have it solved "ralign" thanks anyway!