Search results

I just created a list box based on two fields which created a unique enough way to find records. I wouldn't have known to try a list box had you not mentioned it, so thanks. :)

I need to create a form that will search existing records from a query record source, and then be able to update the data tables to new values when necessary. The first problem is with the search. When I search for a record with Item# 'xxxy' the form displays the "first" record with said...

Every section that I know of... I attached a screenshot.

Still stumped

I've stumped myself yet again. I want the entire backgrounds of these reports to be the same shade of gray, but it's not happening. I try opening the subreports in design view and applying the background color everywhere possible, but still it leaves the white boxes surround the subreports...

I just sorted the access objects into "Tables and Related View" then it had to update my links, then when I sorted by "All Access Objects" it would tell me which tables were linked and which were local. I just deleted all the linked tables at once since I won't be needing them. And now the...

I can use it to update existing links or to prompt for a new location of he linked tables, but there is no option to disconnect completely. I suppose I could move the back end temporarily (no one is currently using it) and then refresh the links and see what happens.

Great. Is there an easy method for disconnecting aside from deleting all of my linked tables?

Should I make local copies of my back end and connect to that, or should I disconnect altogether? It doesn't really matter to me as long as I can then export/import the new reports into the original Front End.

Makes sense, but the tables I'm using for the report are local.

No, it's a locally stored db, however it is linked to a back end that might be used by others occasionally. Now, after creating a new report and still being opened exclusively, the new report is exhibiting the same extremely slow behavior.

Why when I open my database exclusively do my reports open in design view instantaneously, but when I open my db normally they take actual minutes to open??? :confused::confused:

Ah, forgot about the subquery! I will give this a shot.

I have a query that returns Line, Item, Count of Store. The idea is to get a total count of stores that stock a particular Line, Item combo. The problem is that the table used for this query stores a Line, Item combo multiple times if the Item is located in more than one place throughout the...

Well, I need to exit the macro created in Access not the actual VBA function. Does that make sense? The macro was created in design view in Access and not in VBA. I'm going to convert it to VBA though which should make it much easier.

I use the variable check, because I'm going to need to check the same query again for records later on in the function/macro. I don't seem to have an Exit Function that I can find. At least when I use "DoCmd." DoCmd.Close closes the macro, but for whatever reason it continued to run the...

Actually if I could just get the correct command to Stop or Exit the macro I would be fine. Here is my admittedly ghetto VBA: Public Function TEST12() Dim Check As Long If Nz(DCount("Line", "qry_Product_Manager"), 0) > 0 Then Check = 1 Else Check = 2 End If If Check = 1 Then DoCmd.OpenQuery...

I need a VBA command to stop the current macro (created in Access, not VBA) if a condition is met. All I have been able to find so far is to use the SendKeys command to send CTRL + BREAK, but I can't get that to work and it's certainly not the most ideal method.

Nevermind good sir! A little tweaking of your code and it works just fine. Thanks!

i.e. It can only return one of two values - 1 or 2. Month1 isn't stored in a table. It's a value created within the query by this code: Month1: Format([Month],"General Number")