Search results

wow! i thought it could be done much simpler. would this work in a query? i need to send the query to excel to be processed from there?

thanks for your quick response. can you please write the coding for that. i'm new at this. thanks so much!

i am getting info from a table that has city, state zip as 1 field. i only need the zip info. some zips have 5 and others have 5+4 digits. the info has spaces between the city, state and zip (Beverely Hills, CA 90210) so i can not use the instr method. can i do something that will just give me...

i am looking to make statements. i have a few different dates i need the program to figure out. firstly, a person can be billed for 1,2,3 or 6 months at a time. that info will be in the table as numbers. i want the program to figure out the effective dates, ie: if he is billed for 1 month at...

i figured it out. i use DoCmd.GoToControl "[debit amount]" cancel = true it stays in the same record.

i tried to do this too, but i get a error message: Expected function or variable; This is my coding: If [debit amount] = 0 Then MsgBox "You must enter the amount of the transaction.", 0, "Can not be saved. Missing Data" Me.[debit amount].SetFocus = True I tried to do...

i have it on the onformat of the section that the fields are in.

this works for me! with balance being the field name If (Me!balance) < 0 Then Me!balance.ForeColor = 255 Else Me!balance.ForeColor = 0 End If

i found a good solution (for those who will read this after i am done) on the on_click of a the preview button of the form where i am to choose the account, i added this code. works great! Dim stDocName As String Dim strAccount As String stDocName = "Transactions"...

i was able to connect after all. (there is a type in the address you provided in the word microsoft. i typed it myself and connected)however that site does not answer my question. any other suggestions?

can't connect to that site. any other suggestions?

i have a form to get the account name to print a report for just that account. i want to have the option to print for a specific account or to print for all accounts. i know it can be done by leaving the combo box empty. i just can't figure out how. i really would prefer to have ALL as the...

confused. can you explain that better? where would i put that coding? i need the running balance to start from the balance of specified date and end at a certain date. (all transactions from 3/1/00 until 5/1/00) although there may be balances from before and continue thereafter.

i know i could do that. but i also need a running balance starting from whatever point the report begins. for example. if the reports asks for the 20th transaction - 30th , i need a running balance starting from the 20th transaction. since i am not saving balances at each transaction, how...

i have to make a report that will list only those transactions >= [begindate] AND <=[enddate]. I also have to include a running balance only for those transactions. So i wrote this coding for the OnFormat of the Detail section of the report: Private Sub Detail_Format(Cancel As Integer...

i have a report heading that states the begin dates and end dates for the report. It shows up fine in the header, but when i want to put in the page footer, the dates don't show up. i tried copying and pasting the field from the header, but still doesn't work. it just shows "For transaction...

we want to be able to view just some of the transactions. (basically selected from a form. we pick begindate and enddate) we also want to see the running balance. but since we are not starting from the beginning, how can i present that info?

i was able to get my margins corrected by changing the defaults in Optins/ General. I can't seem to get the default of orientation to be portrait instead of landscape. any suggestions?

how would i write that? where would i put it?

i know i should be able to find the answer to this on my own, but i can't. I have a dailog to get dates and company name for reports. i have this coding set to trap for errors. if there are no errors, open report. If IsNull([begindate]) Then MsgBox "You must enter a beginning...