Recent content by ggodwin

Folks, I am having a problem with a function. The function is copying text from another form and sending it to other records in the same table. The table is formatted as a memo and when I enter it manually into the form I never get a problem. However, the function skips the manual entry for me...

I have not implemented anything. I have checked just three computers. #1) No problem all functions are fine... #2) Read Only #3) Is getting an error stating a table is missing when it is not. (#1 PC can run it fine also) This is on a shared drive.

Creator : Acess 2003 SP3, Created with Window XP2 User with Error: Acess 2003 SP3 Windows XP2 All the same

I am getting a Read Only error for one user? Is there a setting anywhere that would create this?

Gald we could help. My problem was fixed with I realized I had misspelled a entry above...

I have a table [QREVALUE] That has some incomplete data because I did not give enough text places when I initially set up the table. I would like to go back and repair the missing text with the correct text from [SkpiProblemLog] Both tables have a comon Unique identifier in field [TagNumber]...

Instead of short date can I give it mm/dd/yyyy. I actually need to force this format. I assume I can use this instead of the short date and also use Date()

Thanks!! Got it. Is there any tool that will save various Passwords and usernames?

I have a database query that I would like to send to another database in another location. currently I am using the below code. However, this is sending the query as another query. I know I can change this to a make table query and then send a table as a table. However, if possible I would like...

1.) I have a date form that I would like to maintain the format of mm/dd/yyyy and I would like the default date to be 01/01/2009. 2.) Along this line of questions. I also would like a different date field to also have the format of mm/dd/yyyy and have the default of "Today". Any ideas for...

I have a password form and would like the password to be indicated as "*******" Instead of the actual letters/numbers. Is there a setting I can use to force this?

Bob that is funny you bring this up. My managment wanted it to all be one little place like you mention. However, because of several problem we are moving it to be tables. I am simply testing the methods that we will use to update the backend tables. I am just trying to keep everyone out for...

I just want to preven them from entering while a tweak a couple things..

As an Admin can I lock Access so that users can not use the database for a short period of time? if so what are the steps?

I have the below query SELECT [DENSO Plants].[DENSO Plant name], SkpiProblemLog.SupplierCode, SkpiProblemLog.NAMC, SkpiProblemLog.Type, SkpiINVESTIGATION.Responsible, SkpiProblemLog.Date FROM (SkpiProblemLog INNER JOIN SkpiINVESTIGATION ON SkpiProblemLog.ScrapRecordTag =...