Search results for query: *

This was moved from the VBA Modules forum as I think it's starting to apply more here, maybe. What I'm wanting is to have a report field based off a value passed through VBA. The field, a textbox, is in the detail section, and at present the code that I have written populates it with the last...

I'm trying to get the information from my recordset into a field on a report. It's almost working, that is of course, almost. In the details section of the report, it does display the last number in the record. But I'm wanting the field in the details section to display each and every record...

I have a field on a report that needs to use an IIF statement, I need it to say something like this: IIF([SalesType]= 1****or 101, or 201****,1,0) and in another place: IIF([SalesType]>99****AND <199****,1,9) So basicially the first IIF statement needs to see if SalesType has either the 1...

I have a form with a text field (text1) that someone types in and an option group that the user has to select. Depending on what option a user selects, I have code that adds to it. Let's say the option value is 1, then code adds 100, and then that value is written to another textbox (text2)...

Hey if anyone could help here that would be grrrreat! I'm practicing with ADO on a very simple form. The form is unbound with two controls, a text box, and an option group. The text box is elagantly called, textbox, the option group is likewise called, optiongroup. I'm using ADO to add a new...

I have a variable, let's say intSale, that I need to be inserted into my Sales table, in the SalesType field. The variable is a number, being passed into the SalesType field which holds a number value... intSale holds the value of an option selected from an option group on a form. Here's the...

I have an option group on a form that has 16 different selections, and the values are 1-16. They are stored in a field Called Reg in a table named Sales. What I'm needing to do is extract these values as something meaningful in a report by way of query. I need the query to find a particular...

Hi, I'm having a bit of a time doing this, so any help is appreciated. What I need my code to do, is look up a value from a table, verify that value against what someone typed in, and then execute the next portion of the code. I can have this take care of by a Dlookup function, but I don't...

First of all, sorry for posting this to two different forums, but I wasn't sure of the best one to post to. Here's what I'm trying to do, have a SQL statement Insert info into a table, and then verify that info from what someone typed in from a text box. My problem is coming in at &quot;If...

Here's what I'm trying to do, have a SQL statement Insert info into a table, and then verify that info from what someone typed in from a text box. My problem is coming in at &quot;If LocalUser.Password =......&quot; It tells me an object is needed. What's the syntax to type in to pull up this...

Hi, I'm just getting started with SQL Server, and I've run into a bit of a problem. I have upsized my Access database, but in a few of my old queries I have query fields based on a parameter sent to it from a form. Those queries won't upsize, and in creating a new view I'm wondering how to get...

I'm wondering why,,, if I have a form set up based on a query and everything works fine, why would it not work fine if a change to the underlying query was made? The query name is still the same, and it is still gathering the same data (just in another way, I'm not using a dlookup statement...

Hey I'm drowning in a sea of Dlookups. I thought they were a really great idea, and the only fix that I knew of when I created the database. I was the only user though too.. But now.... My company decided to use the database system wide, about 300 people. It needs to be upgraded to SQL...

Anyone care to straighten this out? I have 3 text boxes in a report that are: &quot;Orders&quot; &quot;Canceled&quot; &quot;Finished&quot; &quot;Percent Finished&quot; 124 26 98 ????? I'm needing to find the percent of finished orders. The calculation is a...

Can I filter a subform with a dlookup statement? I have a subform that is based on a query. Each individual user in the database has his/her own salesID. This salesID is written to a LocalUser table when someone logs on, and then the LocalUser table's records are erased when they exit. In my...

I have a form with a subform attached to it. After I login to the database, it automatically pops this form. Everything looks fine, except that there are no records. What is throwing me off is that when I hit the design view, and then the form view, even if I don't make any changes, the records...

I have a form with a subform attached to it. After I login to the database, it automatically pops this form. Everything looks fine, except that there are no records. What is throwing me off is that when I hit the design view, and then the form view, even if I don't make any changes, the records...

I have a form and a subform. The form feeds data to a query. On the click of a button, the subform sets it's property to visible. That works fine. What I want it to do is become visible and popluate with the data from the query. Do I need to put a &quot;me.requery&quot; in, and if so, where...

Hi, I'm trying to calculate a few fields in a report. All I need to do is find the total number of sales that are finished, and the total number of sales that are canceled for any certain employee. Then I need to calculate a percentage based on the completion of their sales. I have 3 different...

First of all I want to say thank you to everyone on here who participates. I have been amazed not only at the depth of knowledge that many of you have, but the willingness to help each other out. Through many of your posts I've put together a database that almost works! woo hoo! I'm needing a...