Search results

Re: (Solved) Populating one text field from another Thanks Minty for your help, once I made the changes everything fell into place, to re-assemble the field types from number to actual text for part number, Organization and Technician i used a query and built relationships that pulled it all...

Ok, this is a really scaled down version of my database due to who I am writing it for, so it looks really bad, but the un-scaled version looks pretty good except for the DLookup and Qty field issues. Thanks for taking a look...I'm sure you know how to bypass the security level login...

Actually I am scanning the part number into the part number field and then trying to populate the description field with a description of the part number whether it is scanned or entered manually. The part number field is a text box and the description field was originally a combo box where I...

I get that on the qty field issue, unfortunately I am still hung up on the dlookup, trying to enter a part number on a record add and have the next field "description" automatically show me the nomenclature of the part number. It would be best for me to keep it simple at this stage, I just need...

Having only one qty field, how can I calculate what is added to inventory and what is subtracted? Currently I am calculating through the query.

Could you be more explicit with your description, I am not sure how you are applying "String"...as in a specific data entry in the field? "tPartNums", is that a specific part number I am looking for? I want the field description to be populated with the description that fits the part number I...

I have two tbls, one called Inventory and the other is called description. Inventory stores all the users input data, the fields are: ID, Part Number, Description, Date, Technician, Notes, Organization, Qty Add, Qty Subtract and Requirement. Description is a tbl where I store the fields: ID...

Solved...what was holding up the validation on my combo box field was the default value in the tbl being set to 0, not sure how that setting got there but I removed it and all works well. Thanks pbaldy, you helped point me in the right direction and made me think.:)

Limit to list is set to yes on field properties for all number type fields, in the main table, required is set for all fields.:confused:

Is it possible to validate a combo box with this field type? I have all other validations working but they are text boxes...I have searched here and the web but unable to find the answer? I want to make sure the field is not left empty, other cbo boxes work but are of a short text field type...

Thank you both for the recommendations, on my form I have the image box and I am setting it's control source under the data tab to: =c:\icsdb\pictures" & [part number] & ".jpg" But it does not display anything on the image box...Am I using the correct control source? Also am I using the field...

I have setup a form that has links to images stored in a folder and the path to those images listed in a table and it works good, however my question is the data I am linking images to is a text field in the tbl called part number. When i enter another record into the tbl that has the same part...

Hey Jerry, Are you still in need of renaming a PDF file? If so, yes you can rename it, but you should maintain the file format (PDF) if you want to open it again..The prefix can be renamed to anything that is supported by your OS's naming convention. John

Sorry for the delay, was on a long weekend...I believe, when you add form fields to a document, all the pages that have form fields will be protected, you would have to make separate documents, but you can combine form fields and other extraneous text together on one document.

If I understand you correctly, to insert form fields into a document, select the form toolbar from the view menu and from there you can choose the type of form field you want. Be sure to lock the form field by selecting the protect form button on the form toolbar. Hope this helps....

I have had great success using the mailmerge system and multiple form letters for some 8,000 records in Access, I found it to be the best, and most reliable once setup.. Good Luck..

Thanks for posting the routine above GHudson..I was having the exact same problem, where all zeros where being written to the table, so I added the DoCmd.CancelEvent, and now everythings works great, I just wanted to take the time to thank you... Reseacher:D

On occassion I have copied a previously completed database as a template to keep from re-creating forms, tables etc. However, when I receive error messages like canceling a hyperlink button, I will receive an error message where the caption refers to the previous database name. How can I change...

GWB's Mismanaged Administration Except for one other thing: Why were we attacked in the first place by Al Quida and what has been the GWB administration or previous administrations involvement that brought all this to bear? :mad:

I found the solution to my problem with the help from Rich and Spacepro, I posted it below: Private Sub Amount_BeforeUpdate(Cancel As Integer) Dim stramt As String Dim strtop As String Dim amtname As String stramt = "0" strtop = "200000" If Me.Amount = stramt Then MsgBox "Jackpot amounts...