Defining Variables

[HelpNewtoAccess]

ok thanks

 

[Deleted member 147267]

Some side notes - all meant in the spirit of education, not criticism:

ID is a meaningless name for a field. GraphicID would be far better for a table named tblGraphic

NoteID PK should be autonumber, not number, and AutoNumberID is of no use - unless maybe you're using it for some sort of numbering scheme. However, I don't see why notes would need any sort of serialization scheme.

Ditto for tblEquipment

Following these suggestions would give you GraphicID in 2 tables, which is why it's usually better to identify at least which is the FK field: GraphicID and GraphicID_fk or GraphicID_pk and GraphicID_fk (or drop the underscores)

Whatever BasPoint is, I kinda doubt it has a phone number, in which case it's not an attribute of the entity and doesn't belong there. Since EnteredBy is short text, that means you must be using real data as foreign key values - or what should be fk values (OK, really just values since you don't have a parent/primary table) which means you need a personnel table. If Jane Smith gets married and her last name becomes Brown, should you have to update every such field in every record in every table that uses it, or just in some personnel table in one record?

There is no pk in tblBuildings. I'd consider that to be a shortcoming that WILL bite you one day.
That's all for tonight as it's after 11 PM. Will see if I can work on your search question tomorrow. I figure that these functional issues might as well be looked at first as it's likely that record source design would have to change to some degree, and it suits my currently short available time slots right now.

 

[HelpNewtoAccess]

Sorry I think I wasn't clear enough I don't need help with the relationship part of the database this is a just a test db (old test db a complete mess to lazy to fix the relationship part before sending it out). MajP helped me with this a long time ago and I have it perfect not like it is in the sample test db at all. I just need help with the splash screen and the equipment form search and to show you the idea. Thanks again for the help and all your ideas were great.

 

[Deleted member 147267]

Gotcha. I think splash is ok now. On my phone and company coming so nothing else I can do until tonight at the earliest.

 

[HelpNewtoAccess]

ok great

 

[Deleted member 147267]

Didn't get to look until after 10 PM but here's what I've got for you thus far: You asked
If I click on search with an empty text box(Text35) it will bring up all the records in the query. I would like the search to show the records only for a single Bldg AFC or BBB when I do this and not see the records from the other buildings. How could I do this to prevent having to make multiple queries and forms and filter this way? I also don't want the user to have to filter themselves with the search button for the building.

Maybe I don't understand the last sentence. You want to search for one building but you don't want to have to use a button? Then change the textbox to a combo
- row source: SELECT DISTINCT BldgAbb, BuildingName FROM tblBuildings;
- width .75"; list width 2.25"; 2 columns: 0.75" and 1.5" wide
- AfterUpdate event:
Me.Filter = "BldgAbb = '" & Me.cmbBldg & "'"
Me.FilterOn = True

Then you don't need the clear or search buttons or any code related to them. This will only allow you to search on one building value, but that is what you asked for. However, if you want the form to open with no records, then you need a different approach as per last paragraph in this post.

STARTUP FORM
I create a 1 pixel bmp image with the same name as the db (Test.bmp) in the db folder. This is supposed to suppress the Access splash screen, but for me it's too fast these days to be sure. Of course, you have to launch the db itself, not Access. Open Access first and of course, you will see the Access splash screen.

Set the startup form to be your splash form. This form gets a Timer property (say, 3 seconds) and a Timer event with
DoCmd.Close
DoCmd.OpenForm "frmSearchAfc"

Splash opens up (use an informative form with things like db title, version number, copyright etc.), stays visible for 3 seconds and main form opens.

If you want this main form to load in the background because it returns lots of records, then use the timer event to open the main form hidden for a period of time, then close the splash, then unhide the main form. Either way, the main form is going to open with all records showing because the combo will be empty at that point. If you want to open it blank and stay that way until a combo value is chosen, you do not set the form recordsource property in the property sheet but instead add code for that in the combo after update event.

Later....

 

[HelpNewtoAccess]

Search Button...………..(can't use combo didn't work well had to change long story short need multiple search fields)
I want the search button to work for only the records in that bldg. as I have a 100+ buildings with tens of thousands of records. I want to filter out the rest of the buildings when I load up the form and keep it that way. (without having to use different queries or forms for each building)

Splash Screen or Loading Screen
Splash screen just want it to mask some forms when I maximize them. It is very quick but doesn't look like a clean load for some of my forms. So the code would look like what for this main form or form I want to go to? (on timer event - Hide main form - close splash or loading form - then unhide correct?) Tried so many combinations with all this.

Thanks for the help....

 

[Deleted member 147267]

(can't use combo didn't work well had to change long story short need multiple search fields)

Sounds familiar, but perhaps is simply another example of "can't do" because you don't know how? Regardless, things seem to be getting somewhat cryptic. I mean, if you need to search on several fields but you post something that indicates there is only one field (because you only provide one control and say nothing about multiples) then I'm either wasting my time providing what isn't wanted, or I missed where you indicated that, in which case it's my fault. As for the splash screen, it seems you don't want a splash screen - you want a "wait" form - something to indicate loading but for several forms, kind of like an hourglass thing. Another misunderstanding?

I can't understand why you'd want to "mask" (hide??) a form when you maximize it. The whole point of maximizing is to make the form active and enlarge it to the max. To want to cover it up with something during that process makes no sense to me and I'm not even sure it's possible. Perhaps you should be using overlapping windows, not tabbed forms?

Maybe provide a link to whatever thread where you said you can not use combo like millions of other people so I can read up on it and maybe understand? The need for searching on multiple fields (whatever that means) implies more combos? Especially since you're filtering on existing data? To allow people to freely type search values in a textbox is not a good idea IMHO.

 

[HelpNewtoAccess]

Combo Box
I don't know what to say but combo box option has already been decided not to be done. Not to say it's not a good idea. Try to explain better 100+ buildings want to search any kind of phrase for equipment. Query made up for all equip for every building. Don't want other buildings because search could bring up 100+ records for say a search of pump 1. If the form loads for one building will show only one record if search for pump 1 is done. Users should not have to search for the bldg. BBB then have to search pump 1 if they are in that section of the db.

Loading Screen
When I open a form and it looks unpleasant to the eye as some computers slower then others I need to mask the screen until it loads. Pop up, maximized form on some forms very unpleasant to the eye even for a second when it loads up.

 

[Deleted member 147267]

want to search any kind of phrase for equipment.

OK, no combo. The quoted statement doesn't help because you search data in fields, not phrases. If you're asking to have one textbox and have Access figure out what table and/or field you want to search then good luck with that. It would explain why you need hundreds of forms though.

I'm going to drop the search and splash thing because discovering the whats (like "mask the screen") and the whys are too tortuous for me. Maybe I will figure out something regarding the images and button placements, but I'm somewhat reticent because of the objections that will likely be raised. I'm beginning to think that even if anyone can figure this out for you, there's no guarantee that you won't just keep what you already have (especially if it's working) rather than start over. I have no desire to prove anything if you're happy with what you have.

 

[HelpNewtoAccess]

My terminology is not good obviously. Yes looking in fields in one query for barcodes, nameplates, amperages with the text box search(Like 10 fields). I guess I was relying on the test database too much to see what is going on with the form. I’m open to changing anything but this has been decided and there was a couple meetings on how the search would be done. I started with just 2 to 3 combo boxes and it blew up from there.

 

[Deleted member 147267]

I’m open to changing anything but this has been decided

Well, that's another example of mixed messages. I and others have posted how to reduce the number of forms but given the way this has gone, I'm going to leave you to either design accordingly and implement those suggestions or not. I cannot help but think that I'd do all that work only to find that you or your boss decided to stick with the status quo rather than dump all that work. I wish you good luck with your database.

 

[HelpNewtoAccess]

I appreciate the time you put in trying to help me. Thanks!

 

[Deleted member 147267]

You're welcome.
Don't know what your management's mind-set is, but you could always plant the idea of getting something done professionally. It might seem more attractive to stay the course rather than spend money but in the end, the many hours you have spent on this might be dollars down the drain when you leave and no one can manage it, or worse, it just stops working.

 

[HelpNewtoAccess]

When someone goes low just go higher. Thanks again for everything.