Search results for query: *

Thanks for the help Lupins but I can't figure it out. I put a comand button in my report in which I was going to put this query in the code builder on the event in the properites of this command button. however it doesnt seem to let me put code in the event tab as it is a blank tab??

I am preety unfamiliar with reports. I want to generate a report, when my table (generated from my form) has the following value: Date Needed is after the Date Recieved. I would like it to generate the day after the date needed while the date recieved field is still blank. ex. in my...

Is it possible. I have a table in which. I have a system and a inbound system and a series of questions. What I want to do: When Entering the system name and the inbound sytem on the form I want a new table to be created tracking only this info so i can run a report on it. Thanks for the help.

Is it possible. I have a table in which. I have a system and a inbound system and a series of questions. What I want to do: When Entering the system name and the inbound sytem on the form I want a new table to be created tracking only this info so i can run a report on it. Thanks for the help.

I want to change my scroll bar on my form from the default Record: |< < 1 > >| >* of 43 to something more user friendly like |PREVIOUS SYSTEM| |NEXT SYSTEM| Anyone know how to do this and can help me. Much Appreciation, Ankur

Nevermind, my supervisor just told me something different. I just need to add the item in the database. so i think i am just going to use a simple text box. thanks for all the help.

i didnt read this part in the FAQ where you wish to limit the user to choosing entries from the list, i dont think that would make a difference altho i did add it and try The later part of this statment is what i was hoping to accomplish -> but allow the user the option to add new entries to...

Thanks PHV, Ok I got rid of that error but the program is not working. What happens is I type in the item i wanna add then hit enter. I get the prompt Add item, I click yes and the orignal thing comes: The text you entered isnt an item in the list. Please contine to help, Thank you very much...

Form_Data Request List is how it is in the window to the left, i even tried using other forms but the same error keeps popping up. I am 99% it the right name now but why an I still gettin the errors?

Yeah it version 2003 frmData Request List frmData_Request_List formData_Request_List Data Request List Data_Request_List and others like this This is my code in caps is my problem: Private Sub Request_Item_s___NotInList(NewData As String, Response As Integer) If MsgBox("Add to List?"...

arghh, cant figure out what the form is called for vba Its Data Request List ive tried a number of diff options!!

sweet i am doing that now, i just can't figure out what the right name of my form is I changed the combo box name and it works til it gets to the name of my form in the code then it doesnt recognize it. This is preety basic question but how can i find out what my form name is for the vba portion.

I just tried messing around with the subform and do not know how to use it. The combo box Idea was exacly what i need to do. I am preety close I searched for the faq but there seems to be a lot and not directed to this. Once again I am a first time user of this forum and your help is greatly...

I don't know ill give it a shot. Im not an expert tho, can you maybe tell me how to use it?

I think this is what i Need to add: it will trigger the Not in list event where you can capture what was typed in and store it in the row source of the combo box. There are FAQs on this site which will show you the code you need to do this. I am a first time user of this forum thanks for all...

Thanks Jeff, It looks like its on the right path. But it still isnt quite working. I have tghe combo box and am able to type in it but when i hit enter it tells me The Text you entered ins't and item on the list. Select an item from the list, or enter text that matches one of the listed...

Thanks for the reply Ken. I went to the desifn view of the form and added a list box but can't figure out how to get or go about the addItem method. thanks for the help.

I need to make a list box, but leave the feilds blank, so when the user access the form he/she enters text presses enter and the item is stored but is able to enter another as he/she pleases. For Example the form would look like the following: Requested Item(s): Data Report 1 (hit enter & the...