Search results

Right now they are using an excel spreadsheet to keep track of the information and they keep the team information the same unless a player changes a team. Then they change last year and this year team. I don't see how players would show up on every team since you have a players table and "this...

Here is the SQL Code if you can go by it. SELECT Players.[Last Name], Players.[First Name], Teams.Division, Teams.Conference, Players.[This Year's Team] FROM Teams, Players WHERE (((Players.[Last Name])="Is Null" Or (Players.[Last Name]) Like "*" & [Forms]![Roster_Search]![RosterLastNameSrch] &...

It's not opening or you don't have the program to open it? It's 7zip. I've tried uploading a folder and it's content to dropbox unzipped and it doesn't keep things in the right folders. The database has icons, images, etc with it. Can you open a rar file?

Here is a copy of what I've done so far. Yes, I'm away it's probably not fundamentally built as it should be. I can make any suggested changes if needed and there's some help. I couldn't upload the zip file so here a link to my dropbox file of it...

I'm trying to do a database for basketball that has two tables. One table is Teams and the other is Players. The Team table has a field "Team Name" and the players table has a field "This Year's Team". I'm trying to do a report based of a query. The query has five fields "Last Name", "First...

You would think since it's importing data to a table it could somehow start with the creation of the first record and end when it imports the last.

Monthly I have to import data from an Excel sheet. It takes a while to import so I would like to have a progress bar. There is a small progress bar native to Access at the bottom of the screen, but I would like one in the middle of the screen. Here is my current code to import the table. The...

Sorry for the late reply. I just now had some time to actually fix this thing. your suggestion helped using the code to update the table. I used that to make a temp field and that worked. This process has to be done repeatedly as the excel import is changed monthly so I had to add some code...

Thanks for the information. I don't do a lot of databases, but I guess I know a bit more than the average user. I have Table one and Table two. Both have identical fields except the second table's data comes from an imported spreadsheet. I have a query for a report that lists a match of...

Noob question. Does that go in "Update To"? Do I need a criteria? I would assume it should look like Field: DOB Table: Updated Table Update To: CDate(Mid(DOB, 5, 2) & "/" & Right(DOB, 2) & "/" & Left(DOB, 4)) I get an error "Data type mismatch in criteria expression". I'm assuming this is...

Thank you for the reply. Right now the database imports the excel data in to a table. It pretty much shoots the data in to matching fields from the excel sheet to the matching fields of the table. I guess I need a bit more help figuring out where to put conversion as well. Right now it runs...

I currently have a database that compares some data between two tables such as firstname, lastname, and dob to see if there is a match between two tables. The second table is created from a spreadsheet that is received monthly. In the past the DOB field has been a short date. Recently the...

I'll try tomorrow. Thanks

I currently am working on a small inventory project. I have a table with the fields "Part Number" which is my primary key, "Description", "Cost", and "Sale Cost". I have a second table that I would like to use to keep track of purchase orders. It has the fields "Part Number", "Description"...

I'm not having much luck changing the bound column. The table that the combobox is getting data from only had two fields. I've tried changing the bound column and it seems like it's always using the number of the index field instead of the second field practitioners. For now I just used a...

I can't figure out how to get my query to run from criteria based on a combobox from another table. I have a field "prac" that has entries such as JF, MG, PM, RJ etc. My query has the criteria for prac as [Forms]![PracReportPrint]![PracChoice]. PracChoice is the name of the combobox. if I...

Thank you for the reply. Luckily, there is only one user that enters data in to the database and it seems as though she has been using this database since 2012. Typically, the names entered in to the database are only valid for a year so I think I'm going to just move the database she has been...

I've currently come across the issue where an end user copied the database locally to their computer and has been using it for months and months. After fixing an issue in the database on the server and then finding that someone still had a database bug is how I figured this out. Anyway, what...

There is a one to many join between the two tables. The table that has a ID for primary key and genres is joined by a one to many relationship from ID to genres in the other table (the many). Still not including genres that have no data in the other table. However, I guess it can't do a null...

Thanks for the quick reply. That works to an extent. When I do that I still get the same result. Say I have field genres and the field shows. Two genres don't have any record information. The query is also across two tables. One table just has the different types of genres along with an ID...