Search results

Ahhh ic ic i was doing it backwords. Thanks man! also can someone explain IsNull to me, like is IsNull (<Expression>) or "" Wouls this be a valid use of isnull?

Ok im Reallllllllllyyyyy new to programming in general and in trying to get a search working that as 7 different criteria on a form, all criteria are selected via dropdown and are unbound. i want to open a multiple items form based on a query that i made and apply the 7 criteria and filter...

im trying to make a receiving part on my program that automatically changes the location of the item when it is received. i have up to 10 items that can be in any one received order at a time. i know i have to dlookup the info but what is command to change it? here is what i have so far for the...

Create a Table with the static info make the info the only thing in this table make the column name "Static info" or whatever you wish to name it. Then create another table with the data create a column with the "Static Info" plus your data columns. Link the "Static Info" columns so when they...

Thanks! got it working!

Ahhh Thanks for the DLookup info, how about the login code? Updated the Code, nothing happens when i click the button ><. is my code still wrong? If Me.Password.Value = DLookup("[Password]", "User Name", "[User Name] = " & User_name!User_name) Then DoCmd.Close acForm, "Login...

I needs some insight to creating a button that will search about 6 or 7 critiera that i set Via dropdowns or inputed text. im very new to VB and trying to learn. Also i would like to Print the search results VIA a report design i have created. any help would be great like commands i need to...

Still trying to learn VB i cant get my Login to work.:mad: The table i have my user names and passwords stored on is called "User Name" The user name column is "User Name" and the Password is "password" The Login Form Name is "Login Screen" one drop down box with the user names in it named...

I tried creating a form from the query to see multiple items but 07 is not apply the filters at all. it just comes up blank, even when i enter valid criteria.

The Code Here is Good but i dont quite understand it what dose the Me.XXXX function do? also i think some of the functions might be laid out a little differently now any advice to updating this to 07'

Still trying to learn VB i cant get my Login to work. The table i have my user names and passwords stored on is called "User Name" The user name column is "User Name" and the Password is "password" The Login Form Name is "Login Screen" one drop down box with the user names in it named "User...

created a form with several Drop downs, S/N, Location, Manufacturer, Model, Model Number, and Owner. All the drop downs are based off of forms, i queried the main inventory to have this info and a couple peaces of information. applied the relationships. If i try to make a macro filtering the...