Search results for query: *

Hi all- I have a violate ref integrity error 3201 on form with 2 combo boxes bound to 2 separate tables. When I enter a Not On List values the "master" combo box works fine but the "child" gives errors. I am using Aceman NotOnList function. Any help appreceated

hello everyone- How does one go about synchronizing replicated databases on a Virtual Private Network (VPN). I have a master/ server computer connected to 3 off site computers with replicated databases. The Db has a front end and a back end. In similar fashion how do yoiu go about...

I Have a form with 2 combo boxes and a subform. The combo boxes determine what is dispalyed in subform. When I print preview the combo boxes and their values are displayed but there is no subform. How can I get the subform toappear from hidding. Your help greatly appreciated.

Hi - Can't quite get a combo box drop down liast to sort in the order I want. Help appreciated a bunch. I have a combo box on a form whose row source is a table L_RR bound to column 1. The combo box has the follwong format properties Column Count 3 Column Widths 0"; 1"; 0" The table...

Hi - I can't figure out how to procced--- help please. I want to select some records drom a table (based on col 1 being equal t 1 and column 2 being equal to 12 for example). I would like to then change column 2 to( to 56 for example) and append the new records to the original table. I have...

Hi - Please help witH a print problem. I have a form with a subform that is bound to a query & a single table. The form and its subform work just fine but when I do a print preview the subform is blank with no data. The display when property is set to always.

Hello everyone- Would greatly apprciate any ideas on the following delema. I have normalize dmy database and as a result have about 17 lookup tables and about a dozen main tables. With some many small parts its hard to see whats happening. Each lookup table has a primary key shich is an...

Hello Have tried all i know & am pulling my hair out. I am trying to make a PARTIAL Replica using the Partial Replica Wizard but I am returning the full data set. I have selected one table (L_Site) and a single field (Number = 1) but replica db has Number =1 and 2 and 3 etc Is there some...

Hello Have tried all i know & am pulling my hair out. I am trying to make a PARTIAL Replica using the Partial Replica Wizard & am returning the full data set. I have selected one table (L_Site) and a single field (Number = 1) but replica db has Number =1 and 2 and 3 etc Is there some error...

Hi- Could use some help with the subform Sum(IIF()) blues. I want to sum the values in a subform for only certain values. My subform is bound to table M_SchedRecurring My mainform is bound to table M_ReceiptSlip My subform control is named subFS_SchedREcurringCONTROL Source Object...

Hello all. I have struggled with this simple problem for several days & could sure use some advise pointing me in the right direction. Is it possible to find count of controls (Forms(n).Controls.Count) on ALL forms that are closed? Following code prints all closed forms property name &...

HI I am using a module (ref GLOBAL Not In List Event Handler faq702-5205) to allow entering new values in combo box. It is generating the following error: “Compile error: Expected variable or prodedure, not module” The event code I attached to the combo box is: Private Sub...

I have tried everything -please help. I have a report based on a query that is duplicating the query results anywhere from 2 to 19 times. It seems to depend on the number of rows of output. The report has a Report Header, Detail & Page Footer sections. Query: SELECT...

I have developed a Access db that is run on 5 remote computers. Each inputs data for that site that is then combined in a "central" computer. The "central" computer may make some changes to the "imported" Data that then is sent to the remote sites. Generally how does one accomplish...

I have a vba code segment that uses Debug.Print but it overflows after 200 lines and overrights values. Is there some way to extend this to more lines or output in some other manner?? Thanks for any help

Hi - Could use some help with a report format issue. I Have a subreport bound to a query and would like tohave all numbers in one column bold. There seems to be on place to change query's bold, italic, font etc. Help help

Hello - hope someone can help with a sum problem. Report R_DepositSlip bound to M_DepositSlip. The report is initiated by a command button on a form. The form also supplies data from the report. I am having problems summing data on the report. The identical data is summed on the form...

Hi all- How can preview printout from VBA code? I am wasting a bunch of paper trouble shooting a Report problem. The report problem is that the same query records are printed in details about 15 times. What on earth could be happening? Any ideas appreciated

Hello all- would sure appreciate help with a combo box that has he going in circles. When I use the drop down arrow to enter data in this control initially it appears as all blank. Or if I try to enter any data I get ERROR: “The text you entered isn’t an item in the list.” If I change...

Hello everyone- Would greatly appreciate help on a form problem. When I open a form (in Form view0 it opens at record 1 of N. I usually want to add new records and must navigate to last record. Form set as follows: Default View: Single Form* Record Selectors: Yes Navigation Buttons...