Recent content by Jasontm01

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...