Search results

I ran the upsizing wizard from the server and everything turned out well using the FE and BE on the server. I tried to pull the FE(.mdb) off of the server and use it from a client machine and when I open any table, I get the error attached to this post. I have created and tested an ODBC...

It's only 6.5" and the data on the new pages is the version of the report before I updated. It's really wierd. Could two reports be linked together somehow?

I'm new to access and I'm learning as I go. I've got all the difficult stuff figured out pretty much, but the easy stuff is killing me.... I have a report that I just edited and for some reason, there is an extra page on the report that doesn't show up in design view. Is there a way to...

Wayne, Can I post attachments to PMs?

I tried the following: It gives this error: Then the debug takes me to this line of code: Anyone know what I'm doing wrong?

I've added the order field to ShirtAvailability and added "Order" to the SQL Statement, but the size drop down is still out of order. Am I missing something?

OK Thanks for helping!! I'm having a bit more trouble though. I have cascading Combo Boxes. The Shirt Size table is "ShirtSize" and the fields are "Size" and "Order" The following is the code I have. I don't see where I would add the order field. (Sorry if I look like an idiot. This...

I will check that out. Thanks!

I have a drop down list in one of my forms that lists shirt sizes. In the shirt size table, they are in the correct order, but on the form, it lists them in alpha. order.... 2XL 3XL Large Medium Small XL It's pretty frustrating to fill out the form because of this. Any way to sort them...

I have an order form with a sub-form for each item in the order. Because this form writes to a few different tables, a lot of the fields are primary keys of a table. Due to these circumstances, if the user tries to click off of the sub-form, it won't let them go anywhere without filling out...

Is this possible, and how can I do it? Adding a second auto number field to current table and auto numbering current entries? I need to combine some records from the same order number that currently have detailed names. I'm trying to simplify them, but I can't because it creates duplicate...

I'm pretty new, but what do you mean by normalized?

I'm modifying a database for someone in our marketing department. The DB tracks shirts that are given to employees. The area I'm having a problem with has to do with the shirt style. The current categories offer: Long Sleeve (White) Long Sleeve (Black) etc.. I want to combine those two so...

After making the changes- When I open the form, it gives me an error: Compile Error: Invalid Outside Procedure And it highlights the bolded section in the following: strShirtType = DLookup("[Active]", "ShirtType", "[Type] =" & Me.cboType) Active is a Field in the ShirtType table and it's a...

where do I put: strShirtType = DLookup("[Type]", "ShirtType", "[Active] = Yes") ? The code has the following at the top: Option Compare Database Option Explicit Dim strShirtType As String Dim strShirtStyle As String Dim strShirtSize As String Then I've got this- Private Sub...

Yes, Active is a field in the ShirtType table.

I'm pretty new to VB. How do I declare that variable as a boolean? I tried to, but it gives me more errors.

This works great... but how would I define ShirtType.Active as a variable in the code? It works, but gives me an error saying that ShirtType.Active is not defined as a variable. Would I do it here? Dim strShirtType As String Dim strShirtType.Active As String Dim strShirtStyle As String Dim...

I have a drop down list in a form that's the first of a cascading set of drop down lists. It loads the list data from a table that lists "Shirt Type." There are some shirt types that are no longer active, so I would like for them to not show in the list on the form. I don't want to delete...