Search results

I have a list box where records are filtered depending upon the value entered in a text box. All of a sudden strange thing started happening although it seemed to happen only to certain records that are almost identical but perhaps vary on certain characteristics. Example: If there are 3...

For a start, search MS Access help on the topic: Set the value of a control based on the value of another control by using a macro

Very strange because I created a database using tables and fields that you provided and did not get any duplicate values when I created the query.

Also keep in mind that in Access, "" = NULL and Access returns no value " " = Space Another thing. IIf function will display the result as soon as the first condition is true regardless of what the false condition is

John or anybody, In each of my 3 fields I placed your code in the After_Update event but all it did was open my form. Then I tried to enter a new record and expected for this 3 textboxes to be automatically filled in. Obviously the code wasn't firing because the first textbox had the focus and...

Hello John, Thank you so much for that very valuable information. I also have exactly 3 fields where I want to carry value. Wish me luck as I'm very desperate!

If a new record will be similar to the previous one, automatically fill text boxes with that data for the user to edit. On my form, in the BeforeInsert event, I have: Call CarryOver(Me) In the module called basCarryOver this is my code: Sub CarryOver(frm As Form) On Error GoTo...

Help! I'm designing a form in Access 97 where user have to extract different values from one form and all these values are being transfered/saved into another form but all of a sudden I started getting this error and could not add a new record. Run-time error '438': Object doesn't support...

Thanks Rich!

Hello!.....would anyone wants to help me? FYI: Access '97 I have a form that serves as a template. I have (unbound) textboxes for comments where users enter different information depending on the type of task that's being done. I already tried it but when I close the form and open it again...

Thanks!

Hello! Help! Unfortunately I have a very complicated database and without using lots of verbiage I have narrow down the situation and hopefully someone will understand what I'm trying to explain here. txt298 in form2 has value that is coming from form1 and this is what I have in control...

Please! Please! Please! Help I have a very complicated form and had put in too much work. Without having to recreate the design of my form, how do I delete the last page? Have search the Help for topic but couldn't seem to find an answer. Many thanks!

Hello, I created a form to serve as a template and some of the values of the controls require user input. (One reason why a report will not serve the purpose). My boss is getting too fancy and he wants a different header for page 1 and pages 2 & 3 will share the same header. How do I...

Hello Kevin, Thanks for your suggestion.........

Thanks for your reply: Access 97 and no codes. More than happy to send you the database perhaps you can appreciate my problem. (if you want) Quite complicated report.... Thanks

Help! When I do a print preview on my report it displays 1 of 1 but when I print the report I get a total of 4 pages. I get a blank page for each page... Can anybody help me? Thanks