Search results

I have a continuous form, with data entry fields in both the form header and the detail section. I've attached an "On Exit" event to the ProdQty field in the detail section. The prime function of the event code is to run an update query on the table (which is the data source for the form)...

I am attempting to create an index of items in a table. The data looks something like this: Bob...2 Jerry...27 Bob...79 Phil...14 Jerry...53 Bob 102 etc. I would like to create output like this: Bob...2, 79, 102 Jerry...27, 53 Phil...14 etc. Is it possible to cycle through the records and...

Unexpected Loop Results I am attempting to create a form for the automated printing of a series of reports. The form is tied to a query that captures Territory ID, Sales Rep ID, # of Reps in that Territory, Total # of Territories. Once completed, the code behind the form should: 1) Print...

I have a numeric field on my report that I want displayed with 2 decimal places, regardless of whether the 2nd decimal place is a zero (i.e., if the number is 7.2, I want 7.20 displayed). The format for the field is currently Fixed / Decimal Places: 2. The display seems to be ignoring the...

Is it possible to create a custom label for a column header in a crosstab query? My crosstab query displays sales totals for a particular sales rep number (rep # 102 in this case), by month. For example: Month....102 1..........$500 2..........$300 3..........$450 etc. I would like...

I have a form with 25 related sets of text-box controls: Product1, ProdDescr1, ProdQty1 Product2, ProdDescr2, ProdQty2 ... Product25, ProdDescr25, ProdQty25 I need to loop through all 25 to check that the ProdQty for each is correct, and if any of them are incorrect, I'd like to set the...

I am having problems getting Access to evaluate whether a textbox is empty using VBA behind my form. I'm currently using Access 2000 on a Windows98 machine, but I also tested this in Access 2003 on an XP machine and got identical results. The way I’d like the code to operate is if the...

I know I can use Date() to display the current system date on a report. Is there a similar command to display either the name of the current file or the name of the current database? Thanks!!

Problem: Need to compare one table's MemberName (single text field) that contains first and last name together (eg. Boris Badanoff) with another table's MemberName that contains only first name (eg. Boris). Names in 1st table are separated by a space. All first names in both tables are...

I have developed a number of databases for a client over the last few years, many of which are automatically maintained through the Windows Task Scheduler by utilizing the /x Macro switch. All of my scheduled tasks worked perfectly for a long time, but now a problem has mysteriously developed...

Can I use the field value from one form Or from a different form (whichever is open at the time) as a criteria for one of the fields in a query? I'd like to set the criteria for one of the query fields as follows: Forms![FormA]![TheField] Or Forms![FormB]![FieldName] I've already tried it that...

I've created a report with a chart that includes a data table at the bottom of the chart. I would like the data table entries to be in Currency format with no decimals. I've opened the datasheet for the chart in chart design view, selected the appropriate cells, and changed the number...

> In an organization's Membership Database, I am having a problem with the queries that generate invoices. > The invoice type is generated by the following query field: InvoiceType: IIf([Members]![RenewalMonth]=Month(Now())+2,"FIRST NOTICE",IIf([Members]![RenewalMonth]=Month(Now())+1,"SECOND...

Is it possible to capture all but the left two characters of a text field when the text strings are of differing lengths? Details. I am working with Product numbers for a company where Product numbers vary in length. When products become inactive, they remain in the database (out of...

Need to capture the correct months of data for proper sales reporting. There are two scenarios: 1) It is January and we want to view the entire previous year's data (have year parameter working correctly already); or 2) It is not January and we only want to capture data for the previous month...

I have a "New Member" form that is not bound to a table, but is the basis of an append query that adds records to a table (set up this way to enable various combo boxes which are filtered by queries). Is there a simple way, other than closing and reopening, to clear all fields on the form? Thanks

sorry i didn't include email in earlier post. brucesilvers@geocities.com thanks!

I seem to recall that in Access 97 the name of a particular switchboard would be displayed on that switchboard. Now, in Access 2000, it seems that the switchboard displays the database name on all switchboards in that database. How can I get each switchboard to display its name as you move...

Is there a simple way to create a dialogue box that will display messages as a module runs? To be more specific: I have modules that perform data import and formatting functions which can be quite lengthy. I'd like to create a dialogue box that will display which action is currently running...

I've been regularly converting my macros to VB assuming that they run more efficiently as code. Is there really any difference in performance by doing this or should VB be used only for functions that can't easily be coded?