Search results

you've attached nothing. Try to re-attach since that might make it much easier to diagnose your problem.

Q1. If you're not going to be updating customer information on that form, create a query that shows all of the information that you would want to see, then for customer name (Assuming this is what the combobox shows) set criteria to " [Forms]![frmOrder]![cmbCustomerName] ". Then open frmOrder...

Can't guarantee compatibility, but good luck

this thread is now about acronyms we want to use but are too polite to use

Although I have not been around long, I have finally started reading other threads and have been trying to provide my input. It seems to me that many people seem to have one common problem, and I feel that this deserves a acronym all to itself: L2N : Learn to Normalize This might simplify...

Here is my "switchboard". I made this using a regular form, not the switchboard manager, and just used macro code to launch forms from command boxes. This gave me some more freedom with appearance. The tabs were created using form controls.

If there was a built in function for this, do you think 2 people would have suggested doing this in a module?

I never intended for this to be pretty, but it is easy to navigate.

is correct. say you want to show the contacts on frmContacts. add a combobox (cmbCompany) that reads data from what should be your tblCompanies (note: if you didn't normalize in this manner, create a query that groups by company name and name it something qryCompanies) then create a query that...

here is a screenshot of how I would do it. Make sure to change tblStockItems.fkProductID Indexed to "Yes (no duplicates)"

You're problem is coming from the fact that in Image 1 you have one ItemCode in Angle going to many ItemCode's in AngleStockItems (ASI), which means that Each ItemCode in ASI has a single and unique record in Angle. In Image 2, each ItemCode in Angle/Flat/Box is unique, but when you reference...

Thanks, I started to notice bits of security here and there, so I came to the same conclusion as you, nearly the same time I read your post.

I realized after getting a Run Time Error: ...on my university's course website, that there may be a way to import some of their data. Let me mention also that I have NO intention whatsoever to edit or damage anything that they have in any of their tables. The website that I would like to...

How long did you spend digging this thread up?

I've attached what I think would make for a more stable database, I used/covered most if not all of the fields you used. Although there are still a lot of tables I justify that by using multiple one-to-one relationships to solve the problem of making one large table with all the fields (many of...

http://davidthompson.typepad.com/davidthompson/2009/07/word-salad.html It hurts to watch this.

change Me.txt1 = Forms![Frm-RTPwc].ActiveControl to Me.txt1 = mid(Forms![Frm-RTPwc].ActiveControl, 4) 'read from the 4th character or something of that fashion.

What procedure are you using to load the pop-up form?

What if you create an extra column next to the date column and set it equal to the date column, then format it as "General" so that it shows the 5 digit date code i.e. 3/24/2000 displays as 36609 Import the date codes into a temporary table as "long" data type, and then transfer to its final...

I have a form with a textbox "txtDateSent". To help speed up some code/queries, I have created a function "DateGrab()" which reads that text box for the date value (from a datepicker). For some reason it is giving me RTE-13 - 'Type Mismatch'. I think it might have to do with the fact that I am...