Search results

Yes, I agree. Since I am fairly new to this, I sometimes forget that (especially considering the way I have it structured) the child entity will refer to the parent in a way that I don't need certain references in the parent. One of the biggest problems in DB design, at least for me, is...

Hello, One of the functions my database needs is to inventory equipment in relay racks (a couple of thousand). The way I had in mind to implement this is to have a table of racks that users enter with the size in rack units (with other information) and a separate table of 'rack positions' that...

Ok, I found the problem (at least partially). Not sure what I was doing wrong to have all records come up instead of the one specified record but I think compacting/repairing the DB fixed that. So the problem with the report being displayed blank was that I used the default inner join. The...

Actually, no. Now when it breaks it shows a blank form... no records at all. I can confirm that it is the mere act of adding a table to the query that does it. I have identified two tables so far that do it. I am looking at them to try to figure out why but so far they are normal tables.

Ok, so it isn't the number of tables that breaks it... it seems if I add specific tables to the query then it breaks. I am trying to figure out why. If I do, I will let you know. Thanks again for all the help.

Playing with the query... it seems I can have two tables with a relationship between them but if I add a third table something seems to break. Still experimenting.

Your file runs fine and produces the desired output. There is an extra small box under the single record but at least it seems to be working. Now, here is where it gets crazy. I have tested my DB on my system at work and at home (two different Access installs) and it didn't work with either...

Good Morning, I created a very simple table, form, and report to test the WhereCondition of the DoCmd. I still can't get it to work. No matter what I change it to, the report has all records on it. If you have an opportunity, please give it a look and maybe you can see what I am doing wrong. It...

LOL, not insulting at all. I am fairly new to access (well, at this level at least) so ANY question is legitimate. I have the variable assignment before the DoCmd.OpenReport. I am having suspicions that it might be related to my original search query mucking up the works. It is from a thread...

Hi Steve, Sorry, I didn't get to work on it today except to verify that all records are indeed displayed (not just one like I originally thought). Apparently I had to use the navigation buttons to get to the next page rather than just the scroll bars. The database is pretty big, I would have...

The field definitely has the underscore. Here is the SQL statement for the report query: SELECT TBL_Sites.Loc_Code, TBL_Sites.[Site Name], TBL_Sites.Alt_Names, TBL_Sites.[Remedy Name], TBL_Sites.[Location Service], TBL_Boros.Borough, TBL_Lines.[Line Name], TBL_Site_Types.Site_Type...

Hi sneuberg, Thanks for the reply. The Loc_Code field is numeric. I added the debug statement and the string appears to be set correctly. Just to test, I temporarily set: strCriteria = "[Loc_Code] = 111" to see if it would open to record 111. It does not. I tried without the brackets...

Hi guys, I have a report based off of a query which pulls data from multiple tables. I also have a search form to locate a specific record. The search form works fine and on the form I have a button to open the report with: DoCmd.OpenReport strReportname, acViewPreview, , strCriteria No...

Well, the data is a list of subway lines in NYC. The users will be entering locations and will have the option to select one of the lines from a dropdown or N/A if the location is not generally walkable from the subway. The trick of preceding it with a space should work nicely, thanks a lot guys!

Hello, I know how to sort the results of a query alphabetically but I was wondering if there is an easy way to have one specific value out of order. I have a list of about 30 options with one of them being 'N/A'. Is there a way to have the options sorted alphabetically but then move N/A to the...

Ok, I will just add the fields to the Query and refer to them with the column numbers. Thanks ;)

Thank you for the response! I believe you are pointing me in the right direction... I have added my key field to the query (in a hidden column) and I set a text box source to the new column and it does display the value in that field (the autonumber record index). What I would like to do is have...

Hello everyone, I have a form that uses a search example from John Big Booty (which works flawlessly, thanks John!) that populates a list box with search results as a user types. I would like to take it a step further and populate text boxes on the same form with the currently selected record...

Hank from NY, just signed up. I am currently working on a large inventory database and re-learning programming in the process. Many years ago, I knew Visual Basic 3 well enough to write several programs and I have a basic/beginner understanding of Access and trying to pick up VBA. I was looking...