Search results

You are not going to like this answer... You are outta luck. Your only hope is that your deleted backup was saved in your trash bin when you deleted it or you have another backup that you forgot about.... Jack

Hmmm. There are a couple of approaches and I think that I would have the prefix be a separate field in the table(s). If you do that then you do not have to parse or do anything else. The user can select the prefix from a combo box on the main form and they should be good to go. I hope that I...

You are welcome! If you have questions there are some VERY knowledgeable people here so post your question and I am sure you will get answers.... Good luck! Jack

You do not link unbound fields in a form/subform. Not sure what it is you want to do, but some details on what you are after will help someone here to help you. Also, since you already have the left two charactors in the 'Mod1Ser' field you do not want to extract them and save them in another...

My kudos for taking on an important project for your department! I can tell you that I am not an expert when it comes to 'inventory control', but I can tell you that that is not an easy subject. I would suggest that you use Google or any search engine to get as much information as you can on...

Glad to hear you have it working. Continued success... Jack

You web site looks fine! My question is about the Time Matrix database... No matter which 'square' I enter data into it always shows up in the upper left 'Urgent' part of the form? Just curious... Jack

This article may give you some ideas on how to search for multiple criteria. As dcx693 suggested, I would take the time to learn the QBF method I suggested earlier. Good luck with your project! Jack

I would suggest that you look at this article and use it instead of your current approach. Using this approach you can use Or for that particular field you want to search. hth, Jack

Here is one way that you can do what you want. I will assume an unbound control on a form where the user will enter the name of the table they want to create: Dim strSQL As String Dim MyVariable As String MyVariable = Me.ControlOnForm strSQL = "SELECT MyTable.CustID, MyTable.LastName...

I am not aware of any way to open 4 'instances' of a single form, modify them and then place them in subforms. I understand your desire to 'go where no man has gone before' but is it worth it? Other than personal satisfaction I don't see any programming advantage to doing this. As for a...

It should read: Set db = CurrentDb hth, Jack

I would suggest the you change the SourceObject of the subform using code. This way you can select which subform you want to show... hth, Jack

An Update query will do what you want. Search Access help for more details on Update Queries... hth, Jack

Hmmm. I would suggest that you look into normalization and maybe a sample inventory database or two. You do not want to be adding/renaming tables for any reason. Also, inventory control in a database is something of a science and I would suggest that you read as much as you can on this subject...

Modify the customerID where clause like this: If Not IsNull(Me.CustomerID) Then where = where & " AND [CustomerID]= " & Me![SrchCustomerID] End if The '6' in the code is to remove the last AND from the SQL string...

This article may give you some ideas. There is also a lot of good information in Access Help under 'linked objects'. The common dialog box is an Active X control that is available from the Toolbox under More Controls. (I have the Developers Edition of Access and this Control is available, but I...

You have a mess on your hands. If you are not familiar with Access and Access code then I would suggest you stick with your current solution...unless you want to learn Access. What you want to do goes against most database principals so I do not understand why your company insists on doing it...

Not a good idea to save pictures in a database because your database will become huge. Search the MS KB for Linking Pictures and you will find articles there on how to link to your pictures rather than storing them in the database. Then you can use the common dialog box to find the picture and...

If your tables are set up correctly there is no need to save the Category in two tables. If Categories is your Master/Child link then set the Master link to the combo box. hth, Jack