Search results for query: *

I have field Zip and Field Zone in my form. I also have a Table Zones. Table Zones has the following: ZoneID, ZoneZipStart, ZoneZipEnd, Zone I would like the form once I leave the Zip field to fill in the Zone field with the Zone that zip code; For instance if the zip code entered is 20164...

I have the following procedure in a form: Private Sub PlusMinus_Change() PlusMinus = PmtAmt - Total Select Case PlusMinus Case Is < 0 PlusMinus.BackColor = vbRed InvOnHold = &quot;Y&quot; Case Is > 0 PlusMinus.BackColor = vbGreen...

I have a table with the field SchoolName. This field has School names such as: Park View Hs, Herndon Hs, Broad Run Hs. I would like to get the Hs to be HS (both letters Capitalized) I was trying to use: Right([SchoolName],2) = &quot;HS&quot; But it is changing the entire field to -1 Why is...

I am trying to autoate saving a comma delimited file using the TransferText Method. This is my ultimate goal: -Press the ExportConfirmation button -A Inputbox appears asking for the file name -I will enter ConfLtrDt and then the Month and Year -And the file will save to: G:\OE...

I have two tables: &quot;Athlete&quot; and &quot;ExtendedBio&quot;. They have a One to One relationship at the field AthleteID. There are over 15,000 athelete's in the database, but there are only 6000+ Extended Bio's--and I need to have an extended Bio for each Athlete (even if it's blank)...

I have a form &quot;Fulfillment&quot;. On the form I have a command button &quot;cmdPatchReport&quot; with a Macro on the OnClick event to open the PatchReport. When this button is clicked, not only would I like it to run an update querry to update the ItemShipDate to a date that is provided...

My organization has a database called &quot;Orders&quot;. Our customers are able to order Patches, T-shirts, Plaques, and Certificates. At the moment--I do these all myself--each time that we run fulfillment. I would like to start to automate it though, so it is one less thing that I have to...

I have an unbound form called &quot;Orders&quot;, which has about 5 Text Boxes (ShipDt1, ShipDt2, etc...). I have set the format as ShortDate on the form. My issue is that when I have someone's order up--if we have shipped their item to them,the date appears correctly, but in all of the other...

I have two forms, one is the &quot;Orders&quot; form and the other is the &quot;Notes&quot; form. I have put a lable called lblSeeNotes on the Orders form and set it's visible property to No. I have also put a text box called &quot;Notes1&quot; that is based on the notes form and set it's...

I have two databases that I am bringing together. When the data entry specialists are entering the data, everything they enter is in all caps, but we also download some information from our website--and when that information is downloaded, it is downloaded in whatever format the customer enters...

I have a form that is based on an table &quot;Athlete&quot;. The form is completly unbound, and everything is driven by vba. The table has a &quot;Notes&quot; field in it. When entering data into the form you have the option to press F6 to open a seperate form and enter a note. I would like...

I have a form that on load it ask's for the date received, then another one that ask's for an existing id or if you would like to add a new one. when I type in &quot;New&quot; I get the following error: Run-time error '3061': Too few parameters. Expected 4 I am revamping the database, and I...

I am getting ready to revamp two databases into one. One of them is a lead entry db where we enter name and school, this one counts the number of entries made per person, etc... That databases is doing good though it need's some design changes to make it more appealing to the eye. That db...

My organization sells products like so many other organizations. When we receive data forms back from customers we enter the RespondBy date (Date in which they are supposed to respond back by) the Date Received (The date in which we actually received the form back) and the product. I have...

I am trying to create a report that is based on a querry that is based on another querry, that is based on another querry, that is based on a table----and the system keeps getting hung up ie: &quot;Not Responding&quot; is this because I am using to many querries? I would hope that for the...

I have a Crosstab Querry that totals the amount of each item (1, 2, 3, 4, 5, etc.) that each person ordered. 11, 12, 13, and 14 are all T-shirts and somehow I need to add all of them together, but I can not figure out the sql to do it: TShirtTotal: Nz([11] + [12] + [13] + [14]) Does not...

I have a querry &quot;Refund&quot; that should calculate the persons refund that is due to them. The querry is created from several tables. It has the following fields: ID, Name, Address Info (broken down of course), Ship Info, PmtType, PmtAmt, InvTotal, Total, Refund I have cretieria in the...