Search results

how would that work? Would it be a list of textboxes referencing the query im running? If so how do i do that!!

I got it working thanks alot! Jer

Hi jdraw, I know but I was new to access and had the db setup before I knew about that! I tried the code and it doesnt work..

Hi Im trying to put the Nz Function into the criteria part of my query. Basically I hace a list box that shows the tool number and description of a tool. However is the value of the the tool number = UNKNOWN how do I make it such that it will sub in the serial number instead? tool numbers are...

Is it possible to have several unbound textboxes populate with different records. I have a list of tools in a box for example. When i search that box i want the list of tools to appear. I cant use a list box because I cannot format it to the set standard needed! any ideas? Basically Im trying to...

Thanks for the help!!

so is there anyway of having the images change in respect to the record when the form is in continous view??

Ihave a form which shows all tools in a box. I have images that change with each tool record. However when i put the form on continous view only the image of the first record appears across all records!! any ideas? Also is it possible to have the form in single form view but press a button that...

At the moment I have it in such a way that i select the pallet and the list box is populated with the tool numders and their descriptions. My problem is A) I dont know how or if it is possible to change the design of a listbox to look like a gridded table. Tool numbers on left and description...

The above with the textboxes is what I need. I was origionally going with the list box but my boss said it was not good enough and now he seems happy with this idea... Do you understand now.. sorry for the inconvience.. Its like im jumping through hoops!!!

The above with the textboxes is what I need. I was origionally going with the list box but my boss said it was not good enough and now he seems happy with this idea... Do you understand now.. sorry for the inconvience.. Its like im jumping through hoops!!!

The above with the textboxes is what I need. I was origionally going with the list box but my boss said it was not good enough and now he seems happy with this idea... Do you understand now.. sorry for the inconvience.. Its like im jumping through hoops!!!

The above with the textboxes is what I need. I was origionally going with the list box but my boss said it was not good enough and now he seems happy with this idea... Do you understand now.. sorry for the inconvience.. Its like im jumping through hoops!!!

I have a query which pulls up certain info about the tool. Its number and description to be exact. There could be 10 tools for example in a pallet. Im want the tool numbers and descriptions of these ten tools to come up in separate textboxes. This is because the form is goining to be formattted...

u follow??

sorry by box i meant pallet! i have a form that has a combobox with the names of all the pallets. I select a pallet here and it automatically takes me to a form. In this form i have the tool number and description of each tool. When its displayed in datasheet view all the tools are there but in...

is there not a code that i would put in the textboxes that pulls up the tool numbers related to that individual box??

Im not following you.. :(

Ya i got it working. Just needed a push in the right direction. I understand the theory of vba and ms access, im just very inexperienced at writing code and referencing. That and I only started using Access 3 weeks ago!!

thanks for the help guys!