Search results

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

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

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

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

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

I have a database that currently has 2 tables for data and 2 forms for entering that data. tblWork holds the majority of the information about anything we have going on for someone. tblSales is used to store information based on "sales." All the information in tblSales also exists in...