Search results

thank you for all your help the database is now complete and on time. i promise for all your efforts i will start to use error trapping and i will read those posts as soon as i have time. once again thank you for all your help 4 stars to you.

i plan on reading the information you posted but for the sake of ease and time is there a way you could post the code for that which i will use for the on-click command. i tried it as is but it does not work... i start classes on Monday and will have time to read through the links unfortunately...

im sorry im fairly new to this coding would i put that in the onclick command like i have the code now? or is this placed as additional code to the program.

the other question i have is how do i go about trapping this error so that it just ignores it instead of having to debug and close the window

the only users the will use this form are the CEO and the it director of the company. but the issue is that there will not be a generic report this reports will alter each time we will create one so for easy of the program i have made the shortcut button.

I have the button working using the following coding. the issue i have is that either when i cancel the wizard or finish the wizard i get the same runtime error 2501. i would like to get rid of this error since the member accessing this button need to have no access to the actual coding and the...

sweet thanks for your help

thank you with what you put i figured out how to do what i needed. by an chance would you know how to change the value in a listbox. i.e i have a checkbox and in the listbox it says true or false i want the if statement to make it so if false then change false to no. i tried this but its not...

I am trying to format a text box so the item that is display currently a number will be preceded by another number to format it to my current standards. Currently I have the input mask set to "4230000"0 this works for only one record the information for this text box is pulled off of a list...

what i currently have is a list box that lists calls and on the on click command it opens a form to show all the details the forms are working correctly the only issue i have is that the id column which is hidden in the listbox is not updating when i select another item. the code is as follows...

thank you all for your help i have completed the task i was aiming for. and thanks to your help with the code the database is working like a dream

well with a combination of all your efforts i have it up and running the only issue i have is i want to change the account number to start at 1 and go up that was easy is there anyway to format the text-box so it shows 4230000 then the account number, but does not save that as the value? For...

boblarson: i will take this into consideration the reason i start at a certain number is that we are starting this database in the middle of business. Also the number consists of a value before hand the new clients will start with account numbers of 423000044 and up which is why the number...

Chipper T: Sounds like a possible solution how would i go about in doing that? vbaInet: I was taught that a global is the only way for it to store the variable and alter it each time the form loads. the number needs to increase by one for every client we add and if i had in on the form load it...

I am currently working on a way to automatically generate our clients account number. I have the process pretty much working the only issue i have is the global variable does not update. the form reads the variable and does the mathematical calculations necessary but even though i set the new...

thanks for the offer i found the missing reference although i have found another issue. i need to use the dlookup function to find some of the other information that needs to populate according to the information selected from the search. the issue i have is that when i put in the code as it was...

I have decided to go with the Dynamic Search but once i put it into my form every time the form load it asks for me to Input Parameter Value? it also does this when i change data in the search field. Im not sure what i missed Any suggestions?

in regards to this i seem to misunderstand the coding should i put the varible that stores the first name in the location of the quotes for the [First Name] = "" segment?

Thanks to both of you for the help i will look into both solutions and see which fits our form best.

I am working on a database in Access 2010 and i have a client information table that has multiple information i have designed a form to search and display the information. The only problem i am having is the actual search. I want to be able to search by the clients first and last name or by the...