Search results for query: *

While searching for a good search option in access i came across the button "Filter by Form". Now, searching for a record using this method has found to be very simple as it uses the current form that you use to enter the data in, so its familiar to the users of the database. I would...

Thanks for the choices ZmrAbdulla. Alriiiiight, you can get a star too.

Thanks again Bob

Hey, I have a form that automatically starts up when the database starts up. Now when the form is shown at startup it is not maximised and i find it really annoying to constantly keep maximising it. I know this isn't a big problem, but if i can fix it then all the better. Thanks

Sorry, just realised i had posted this in the wrong forum. I meant to post in the the access forms forum.

Hey, I have a form that automatically starts up when the database starts up. Now when the form is shown at startup it is not maximised and i find it really annoying to constantly keep maximising it. I know this isn't a big problem, but if i can fix it then all the better. Thanks

Actually, just send it to nice_n_ezy@hotmail.com Thanks so much. Its so hard to find a good search option in access. Most of the options such as find and filter have their flaws that will make it too confusing for the user. From what i have read from other member responses to yuor search...

Whats the file size?

Well i'm working with Access 97, so the file doesn't work.

Ok, i had an idea where instead of having the Server Name combo box on the form, i would have a button which then asks me to enter the server name to find. This will eliminate the problem of typing in the search information on the same form page. Now i tried it using an access command button...

Hello again, Well i have a field in a form, and if someone was to change the value in the field for a record i want a message box coming up to warn them or confirm that they are about to change the value. The reason i ask this is because i have a field called "Server Name" and then i...

Disregard my previous message. I only added the criteria to the primary key field and it works great. Thanks so much. Your definately getting a star for this one.

So i should put the following code in criteria for only the primary field? Forms![YourFormName]![YourFieldName] So for instance it should be something like this Forms![F_Server_Data]![Serial_No]

Ok, Sorry for the mega delay but i have been so busy lately that i haven't had time to try this. Now, i made a query with all the fields and added Forms![YourFormName]![YourFieldName] to the criteria of every field with the form name staying the same for all fields but with the field name...

Ok, thanks for that The ###.###.###.###;0;_ input mask worked well. See, what happened with the input mask ###.###.###.### was that if you didnt put a space, it would push all numbers over to the left, which would give you an incorrect number. But adding the ;0;_ at the end of it seems to...

Hmm, yeah it works ok, but if i have an IP address like 178.17.133.7 it wont let me add it.

Hey, I'm doing a database for NT server inventory and i was wondering if there is a validation rule or something of the like for entering IP addresses. I tried putting in an Input Mask of "###.###.###.###" but it doesnt work too well. Any help is greatly appreciated.

Hey, i am using Access 97 and am creating an inventory database which has many different types of fields. Now i have created a form for the easy entry of data but i have no idea how i would print the data only for the record i am currently viewing on the form. If i create a report, it has the...