Search results for query: *

Hello all, It's been a long while since I've developed a new database and have forgotten a lot of tips I learned years ago, so forgive me if this seems obvious. I have a table which has a "Level" field which stores the sponsorship level of a sponsoring business. I have "Silver", "Gold" and...

Hello All, I'm trying to use the value of one option group to toggle the visibility of a second option group. The first option group has five options. If option 3 is selected, I want it to make a second option group visible. (Eventually, I will add code to make a third option group visible...

Hello All, I am trying to figure out a way to e-mail the results of a daily status query in text format as the body of the message. I can do it by creating a report based on the query and emailing the report as an attachment. However, no matter what format the report is emailed in (text, html...

Hi All, Pardon me if I have posted this in the wrong forum, but from my chair it was 50-50, this one or Queries. In my db, two of my forms are based on the same query, but calling up slightly different fields and displaying them in different layouts. The db is replicated and the users use the...

Hello All, I have a db which is replicated. Design Master is on my desktop and the replica is on a server. One particular user keeps claiming that she is making her entries but after I syncronize key fields are empty (in the design master). Furthermore, when we go back into the replica, those...

Hi All, I have a subreport based on a two-value crosstab query that is giving me grief. The crosstab query is based on dhookom's faq701-4524. I have modified it and it was working fine. My crosstab query pulls its info from two other "feeder" queries. Both the other queries contain date...

Hi All, I am using the pivot table function of Excel to do some grouping and totalling of information coming from an Access database. I need some help in figuring out how to lock the size of the pivot table. Here's what's happening. In the database, a query selects values of loans coming from...

Hello All, Just when I think I have my report finished, I run into another wall. In my report, I am trying to copy an existing form (3 pages long)which we are required to submit our quarterly reports on. I have created a series of subreports to report different areas of information. They are...

I am trying to find a way of adding sums of numbers together. We have to keep track of where our clients obtain funding from. There are 7 different pots they can choose from. For reporting purposes, we need to merge the values of what was chosen from pot1, pot2, and pot3. I have created...

Hi all, I have a field on a form which shows who updated the selected record last. The field is updated using code behind the form's "On Dirty" event. My problem is that I want the code to execute only when a control in the Detail section of the form is changed. There are controls in...

Hi All, We have gone to a paperless phone message system as part of the db I am developing. A record is entered into the db by the receptionist and when she clicks on a command button it sends the message to the recipient using Outlook. I am using the following code to invoke a blank email in...

Hello All, Our office tracks incoming phone calls, mail, etc. When entering a new call record, the log form looks up names of callers from an address book table. If the name of a caller is not in the list, the code in the "OnNotInList" property allows it to be added. My question is...

Hello again all, My database has an address book feature which our office uses for just about everything. This probably goes a bit beyond your normal Access VB question, and it might get a bit lengthy, but allow me to describe what's going on. I have a button on the Access address book form...

Hello All, I am looking for a way to close a form in code. I have created a form and query which performs a date range search based on thread 701-290001. The user enters a begin date in field 1, an end date in field 2, then clicks a command button which launches the query. The dates the user...

Good Day All, As part of my current db project, I have a msg form which our receptionist completes and then e-mails to the intended recipient. It was working fine until I had to change the msg field from a text field to a memo field (255 characters was not enough for some msgs). Now, anything...

Hello All, I am testing a newly developed database which was to be in full use today, but it is obviously behind. There are functions which work on my machine and another machine in the office, but not on a third machine. No error messages have been popping up. The database was developed from...

Hello All, I have been trying to get a command button to send an email based on modified code from thread 702-396121 and am stuck. I have a button on a subform which initiates data collection from both the subform and the parent form. It then starts an Outlook e-mail in which the user can fill...

Hi everyone, I am looking for a way to filter records shown in a form which has been based on a table. This has to be done "behind the scenes" so to speak, so having the user apply a filter is out of the question. Also, because of the comlexity of the form and subforms, calculations...

Hi, I have a page of a tabbed form with two subforms on it. Both subforms come from the same table. The subform on the left is in datasheet view and only shows the date, analyst's name, and topic of the record. The subform on the right shows the complete record. what I need to do is to be able...

Hi, I've created a 3 choice option group that records whether a contact phoned, came in for a scheduled meeting, or walked in without an appointment. The result of the option group is a number (stored in the underlying table), but for status forms/reports, etc. I need to know the string/text...