Search results

I have a listbox that is populated depend on my search criteria. Unfortunately it doesn't work. I've also made a button called ViewAll so the user can view all the files if they so choose instead of seeing the search results. I figure if i can get this working the rest would be easier to...

can't delete it manually b/c the users don't know what the index is for so I have to use code to automatically have it cleared.

now this may sound silly, but I had a form that could search for items based on values entered by the user and displayed in a listbox. It works perfectly, so I thought I would do a "save as" and make a second record searching form very similiar except for the minor changes in labeling and table...

I have a combobox for users to choose from the pull down, but occassionally they find they want to deleted their selection altogether (but not the entire record). Problem is I have an index field that is filled in depending on the selection, which is used later in another form and things get...

I have a db that is split. When I try and access the tables thru the FE the records of this one particular table is locked! Why is this? It's very frustrating.

sorry, I'm a bit of a clutz w/ this VB stuff. I guess what that does is stores the indexes of the list into the array, but then I don't know how to transfer it to a report?

I've tried searching for this but still can't figure it out. I have a write conflict whenever I close this form. I've figured out that the cause for this is a couple calculating functions that I've made up. Basically all they do is add up number from fields in a subform. I think the problem...

Ok, I've come to the conclusion that there must not be a way to print values in my listbox in a report. I have a listbox that is filtered/populated depending on what letters I type in textbox (eg. find all entrie starting with "tri...") For each entry you can double click to open a form that...

How do I write an if statement checking if a certain tab has been selected in my tab control in my form?

i have an array(9) and want to fill corresponding txtboxes so that array(0) fills txtbox0, array(1) fills txtbox1, array(2) fills txtbox2. is there a way to do this with a loop?

I have a combo box that searches for a record based on the name selected. Each name is associated with an SIndex. Is there a way for it to display a record based on two indexes? The reason is from FormA w/ unique YIndex, all the corresponding records in FormB w/ unique SIndex, are display...

is there a function that returns a value indicating whether an inputted date is a leap year or not?

probably a dumb question but how do i display a certain date in a txtbox based on the values of 3 different fields representing day, month, year?

I am trying to count the number of records in a subform w/ linked fields "Index". The following code works without the "SIndex" criteria, but I want to count the number of records w/ SIndex (of the subform) equalling a certain value. = DCount("*", "Job Summary Query", "SIndex =" & SIndex And...

Thanks a lot! That did it.

it didn't reconize that function. this is the code I am using Dim JTotal As Double Dim rst As Recordset JTotal = 0 Set rst = Forms!Day![Day subform].Form.Recordset Do While Not rst.EOF JTotal = JTotal + Forms!Day![Day subform].Ctl1 rst.MoveNext Loop...

i must be missing something, but that's not it either. I'll email it too you if you don't mind looking at it? thanks

How do I loop through records in a subform to add the values of a certain field to be displayed in a single field in another subform? I am not a programmer, so any helpful details of the code would be greatly appreciated

job hours

Probably an easy question, but how do I check if a record has been selected in a subform?