Search results

Hello, again! For some reason Access has decided to break on one certain event: BeforeUpdate on some sub form. This just started a day or two ago. So I debugged, compiled, etc. That didn't work, so I deleted the code and pasted it back in. that seemed to work for about a day. Now the...

I used a recordset instead. Much easier than trying to figure out how to relate two totally unrelated tables. Now, I can create random strings, at a custom length, for unique IDs. I do not use caps because Access does not differentiate between lower and upper case, natively. Thanks for you...

Well, I left out the part that the random ID's are stored in a separate table. So, there is no relation between the Supplier table and the random table. Supplier Table ID Company RandomString - is currently null Random Table ID RandomString

How would I update a table with values from another unrelated table? I've been trying to use queries to update a table, but i get like 180,000 records to update, but really only 500. I have two Supplier tables, from separate databases that I would like to combine. Both databases have records...

Thanks, guys. I discovered that size matters here as well. I tried using paint/photo viewer to rotate them, but the rotation was not reflected in the form. So, I resized them, and this solved most of the problems. However, I may need to rotate AND resize, as several of the photos are still...

Hello all, I am linking pictures to records for a parts database. I took the pics with my phone, some I took with the phone vertical, others horizontal. It seems the horizontal pics show up just fine on the form, but the vertical ones are sideways. Any ideas on how to get them vertical? I've...

Steve, how did you go about establishing such a beneficial relationship with a professional company? I would like to do the same, but am unsure about who to approach and how.

If you are using windows, you should have a user name, retrieved by a call to some api. fOsUsername is the function name, in one of the modules.

Once you open it and stop macros, enable content, the hidden form should open, then the main form. If you click on the New Request button, that will allow you to fill out the Request form. The search form is opened by clicking on the Add Item button. Click any check box, click Add to Req, then...

Here is my first attempt at a stripped DB. You may have to enter a supplier before entering part number info.

You are correct that this is a lot of extra work. Perhaps the question I should be asking is how would you recommend going about this task: (Some background info) The application opens - gets user name, dept id, user level the navigation form opens - the default form displayed shows a listing...

This works for the first part - form and subform. But I haven't worked on copying data from search form to subform yet. The example CJ gave and your re-written snippet use SQL. Would that be a better option? I'm not sure how I would pull the data from the controls with the examples given above.

Would SQL work better? If so, how would i go about it?

Kind of. I was trying to set the value of a control on the form to the New ID, but I used a variable as suggested, and used two separate recordsets, and now I can fill out a Request. Now, to see if I can copy the data from the search form over into the line item subform. Here is the code that...

Hey all, I have a question similar to this thread: https://access-programmers.co.uk/forums/showthread.php?t=279709 My answer to "why?" is this: the Request form has a subform which holds the line item details for the Request. It has a field for the RequestID (an FK). The problem arises when a...

Glad you got it! What is your solution?

What OS do you play on? And how did you configure it?

Well, I am also a part-time developer, and now have two access databases running, though they are far from finished. There are things I see that could be improved, users always come up with some else they would like. There are still some things I would like to do, just don't quite have the...

Ha ha! I was making some changes a while back and added another field in another table and the form is confused! So was I until I checked BOTH table and query! Solved this one!

Yes, it has a valid control source. The table's default value is set to "no". The form's default is not set.