Search results

I've been using a database that I copied and I just opened the relationship diagram and found that my previous relationships were gone, replaced by three tables: MSysNavPaneGroupCategories MSysNavPaneGroupToCategories MSysNavPaneGroups Where did these alien tables come from and how have my...

I had a GoSub error on the Form_OnCurrent sub when I tried reopening my database today. That scared me so I immediately made a copy of the database. When I open that database, the error is gone, but it appears the changes that I last made (before I reopened it with the error) were not saved...

Thanks. I have a button on a form that opens a query window based on values in the form. When I change values on the form I want the button to update the query window. I'm using the macros and the refresh options don't do it. The only solution I've found so far is to have the macro always...

How do I make fields in a new record (single record display) default to a certain value without having the record checks activated so that it gives me an error for required fields if I try to leave the record without filling in all the blanks? If that's not possible, how would I give certain...

Say I want to create a query or report with average prices for different machine models. However, some machines with the same model can have a different weight. So I want it to group average prices according to a range of values for each model. So I would have a row for each model that shows...

I'm not sure what you mean. I was working on the database directly from the USB stick when the error occurred. I tried using it on a different machine and copying it to the hard drive and it still didn't work. Do you mean to say working directly from USB sticks makes it more prone to corruption?

No, not wireless. Not split, either. And the same error occurred on 2 different machines, copied from a USB stick.

You are, of course, talking about the the back-end and front-end files that result from splitting the database in the Access Splitter wizard, right? It looks like your program makes copies of both the weekly and monthly database at the same time. Isn't there supposed to be a time difference...

Well requerying the subform it's in obviously made a difference in this case. BTW, I edited the first line of the post for your previous post about load orders. edit: I also just noticed that when the list box is "blank", it's really not even there. Both its border and the border for its...

Minty, but how do I find out in which order the subforms on the main form are being loaded? On another note, I'm wondering if someone can explain why something happened the way it did. I have a list box in a subform on my main form, based on a query of orders matching the order id on the main...

Well I just successfully changed the table key setup as advised. So the parent table now is the only Autonumber Key and the primary keys of the 3 child tables are non-autonumber long integers with a 1-to-1 relationship with the parent table. To my amazement, I was able to put fields from both...

Hmm, you're right, you did say to include a code to identify the product type. I think on first read I thought you were referring to programming code. So you agree with the "MS" code I used? You're saying to update the child after the parent, but the information is being entered into a form...

Thanks guys, I tried decompiling as well as overwriting the offensive Form with a copy, to no avail. Luckily I did have a 1 day old copy. I am quickly discovering how buggy this piece of Microsoft software is. Sometimes I get one-time errors out of nowhere that seem to fix themselves. Other...

Mods, I need my latest reply to be approved please. edit: ok there it is.

I don't think I'll be uploading my database here, it's in a different language anyway. What I do post will be translated. Thanks Pat, I didn't think to not use an Autonumber for the child tables. That actually makes a lot of sense and reduces the need for a foreign key that points the other...

When opening my main form or changing records on my main form I get an error from the Form_Current event. It says there is an error communicating with the OLE Server or ActiveX Control. I've pinpointed that the error only appears when the Private Sub Form_Current() event exists for the main...

I have three product category tables -- Machines, Services, and Parts -- and a ProductIndex table that keeps track of items in all three tables. The ProductIndex table contains all of the products, with fields for the ProductIndex primary key, the type of product (i.e. which table it is stored...

so it said a mod had to approve my message and it's still not here. edit: ok, thanks, there it is above. hopefully somebody can help me out.

I ended up using a Recordset Clone with the FindFirst function and Bookmark, since I wanted to move to a record in a record set. Although I'm not sure how your example was supposed to work since that would change the ID of the currently displayed record, which normally shouldn't even be...

Thanks, I experimented with that with good results but now I have a different problem now since I've decided to first try a different organization. I have two subforms sitting next to each other on a main form. The first is in datasheet view, the second is in single form view. The first...