Search results

Yes I understand that. I have another problem which is that I will not be working in this company for long, as I am only a trainee here. Thus I am worried what will happen after I leave. This is why I have tried to minimize the amount of change there are from the original file. My boss also only...

The main problem which I am having is this. The format set by the company is not really set by us, but it is from our client, who chooses the file. I have been asked to create this database for our own internal use, and for external, we have to upload the original files to the client, who uses a...

Thank you for all your help on this. I will certainly take a look at Normalization, but as of right now, I don't really see any other way as the way the tables are formatted is set in stone by the company, I cannot change that. I understand that the solution I got isn't the most efficient, but...

This form will be used in a database for shipments made on a day. We have each table as the date, with which location it is going to, and maybe which truck it is on. Inside each of the table there are part numbers, quantity, and any other numbers which needs to be included. Sometimes, I might...

Awesome. Thank you very much :)

I have 3 tables right now with names such as 20120629 , 20120802, and 20120909. However, I have 3 tables that I have just deleted off. Edit; I have just restarted Microsoft Access, and it seems to be fine now. Thank you to EVERYONE who has helped me along the way, this will help me a lot in the...

Wow awesome, it works like a charm. Sorry for asking again but when I click Search, the first boxes that displays have this as the Table name: ~TMPCLP249751 where the 249751 are random numbers based on the table. After clicking OK to those, it will display just the names just fine.

Thank you very much. It displays the Cancel button now, so I guess that is fine. However, if I search for a value that appears multiple times in a table, when I press OK, it just displays the box again, do you know how I can fix that problem? I just want it so that it will display the name of...

I want to be able to search in all field types, not just text, as some of them are numbers with letters in it, etc. I have tried to put your code in, but now the textboxes just keeps appearing, and there is no way to get out of that perpetual loop :\ If I don't put the first line, and I am...

Thanks a lot, I can't believe I missed that. It works now, however, after the value is displayed and I clicked OK, this pops up: http://i.imgur.com/EJuv5.jpg When I click on Debug, this line is highlighted in yellow: If InStr(1, rs.Fields(i).Value, SearchString) > 0 Then On another note, is...

@accessMSSQL: I have tried what dralloc said below, and it says there is an error at the Public Function SearchTable line, and the Msgbox line. The tables are from excel documents which I have imported in, so they should be access DB. @Dralloc: I have tried changing, and adding the paranthesis...

@accessMSSQL: I have done that and I am getting a syntax error. This is what my VBA page looks like. The textbox's name is SearchBox. The search button's name is SearchButton. The clear button's name is ClearQuery. http://i.imgur.com/MAMoO.jpg

I know that this is not the best database structure, but I can't edit the layout of the different tables as it is something that is set in stone for me. If I could edit how it is, I would have tried to get a better table layout from the beginning. What I need now is a way for me to just do the...

OK, sorry for making it a bit confusing. Each table in the database will be a shipment on a day. the contents of the tables are computers. Each column is the computer part's serial number. So I might need to find a serial number in the database. I want to be able to search the serial number up...

Re: How do I search for a value in all tables? Hi jdraw. I have just watched the tutorial. Everything about that is fine but I just have 1 last problem. That query only searches in 1 table, I need it to search in all of the tables which I have.

Hi AccessMSSQL, Thanks for the code. Right now I have a form which has the following: A textbox where the search string is entered A button that is supposed to search the string when clicked. How would I use that code so that when the button is pressed, it searches for the value in all of the...

Re: How do I search for a value in all tables? Oh ok, let's just say I want to search in a specific column, how would I do that?

@AccessMSSQL: I am trying to search in all of the columns and rows of the table, and all tables in the database. @spikepl: I am wondering how to use VBA to search now. The other one is more open.

Re: How do I search for a value in all tables? @jdraw: There are meaning associated with them, as there are fields, like part number, serial number, time, etc.

Yes they are. All the tables have the same layout. The difference is that each table is created for different shipments going out. Some of the headers are, Serial, Position, Part Number, IP Address.