Search results

Well I dont think it made an MDE, and "compiled" definitely isnt the right term.. but basically these people will not have access to the Developer Edition once I hand over full support to them. They would like to be able to add new users to the database from time to time. Is there a way they...

I have an Access Database compiled with Developer Edition so the users can run it without having Access installed. This database has a login for each user via the workgroup file. This database uses a backend database file for the actual data, the "interface" part of the DB is what is compiled...

I managed to get it to work. As it turns out if a database is secured (workgroup file) the packaging wizard doesnt handle that correctly. You have to start it from the VB code window as an Addin to get it working right.

I have a problem with the Access XP (2002) Developer Edition Packaging Wizard. When I try to package my database it gives an error on the first screen when I try to select the main file. Error: "The file that you specified could not be opened. Possible reasons for this include: -Access is not...

Thanks, I managed to stumble across the problem. The MS DAO was checked in one but not the other. That turned out to be the fix for this one.

I have a form in a DB that I would like to import into a new one. However, when I do it seems to import fine but I get errors in the form itself. If I click on any button I get a variable not defined error and I get similar errors on anything I do in the form. As far as I can tell all the form...

Im wondering if I can create a query to return results in a specific way. What I want is to enter some search criteria from a few different fields that would match exactly then weight the results based on some other fields. example: custLocation 'dropdown box with different locations...

LocationTabs is the name of the tab control itself. I have a field in the table called Location. I have tabs on the tab control named after each of the 10 locations. I have another database that I filter in a similar way with alphabetical tabs and it works fine but I cant figure out why this...

I just tried this one also and it is poping up a box asking me for "Me.LocationTabs" If I type in a valid location the tab shows the correct data, however I do not want it to popup like that. I would prefer it read the location name directly from the tab page name/caption.

Ok, here is what I tried based on your suggestion. Keep in mind, I am not using a combo box for this, I am using a tab control. It should be able to do what I want based on some other things I have read but I cannot get it to trigger the filter. When I did this code nothing happens at all. The...

Ok, as suggested in a previous post I managed to combine my data to one table. Now I have a problem getting my tabs to work right. What I would like to have is a Tab form with 10 tabs. One tab per location. Im trying to get it so when a user clicks a tab for a location it filters the records...

That would require editing data that already exists. I can add a location field but how can I get it to populate it for me. I cannot type it in manually as there are far to many records.

The data comes from 10 different locations and does need to be kept separate. The tables do have the same fields in them but thats really not relevant to the question I guess.

I have a database that has 10 tables. Each table has the same fields but for 10 different locations. I would like to build a form with tabs with 1 tab for each location (table) Is it possible to get the tabs to show data from a specific table? Would I have to build separate subforms for each...

I have an excel spreadsheet that currently has data in a somewhat non-standard format. The first Column contains all the "titles" and each column after that has data in it. I need to import this information into Access but it doesnt give me the option to chose the first column as the header...

Yes, that is how I am doing it right now. I tried using the limit to List property, which works because it gives an error about the item not being in the list.. However once they do that it Opens the combo box (which I dont want it to do) and they have to hit ESC a few times to clear the field...

Ok, I went ahead and changed it to use a query based on the tblWork and "Order Number" not being empty. It seems to work and saves the users some duplicate data entry. (not really sure why it was designed that way in the first place)

Hmm, I guess I could do it that way. The only way I can is by having a query that looks at the "order number" field and if its populated the query shows it. That field is the only way to tell if a particular record was sold or not.

Its just a combo box lookup type of search right now. They type the value such as "214" and hit enter and it brings up the record with that number in it. I am open to changing how the search is done if its not possible to prevent this problem using the combo box lookup but I'm not entirely...

Hi all. I have a search form that looks up a field in a table and returns some info. The problem I have is, if someone puts in a value that does not exist in the table it just returns the data for the first records information or stays on whatever record is already open. This can be confusing...