Recent content by wwiSports

This works, as far as the Dlookup is concerned. It is pulling the correct zones, but it's not saving the zones. I have the following code to save everything: Private Sub SaveAthInfo() Dim strSQL As String AthChange = False Dim dbs As Database Dim rst As Recordset Set...

I am running access 97, and the round feature is not working. I have changed all of the dollar items in the code to currency, but i'm still running into an issue like below: SubTotal: 9.00 Tax: 0.41 Total: 9.41 PmtAmt: 9.41 PlusMinus= 0.01 (Should be 0.00) Any other suggestions?

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...

Actually, the color's above work. (vbRed, vbGreen--it's in Access 97). They have a database in use with those for a year now. I am revamping that database now though, actually pulling two together. The real problem is this. When The PmtAmt and the Total are =, it is showing up as 0.01 in...

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...

This was perfect! Thanks for taking a moment to figure this one out! Now I will have less trouble exporting the information so we can purge it into Adobe InDesign for our book--any suggestions or preperations that I need for that?? Beth

It worked!!!!! Thank you very much Josh!!! Beth

Thank you! I just wanted to let you know that I used Macro's and used a RunSQL statement and it worked. Thank's again! Beth

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...

There is a button to press to open the orders form. The code is as follows: Private Sub Form_Load() Dim AthID As String Dim AskAth As Boolean Dim dbs As Database Dim rst As Recordset Dim rst2 As Recordset Dim strSQL As String Dim x As Integer FrmMode =...

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 got it fixed!!! Thanks! Beth