Search results

this is what i did and it works although i am sure there is a better way. i made a macro in Word - called it macro 1. in it i replace all paragraph marks(^p) with tab marks(^t) and then i replace all ^t6 (6 being the digit that marks new record) with ^p6. then i save the file. (the code is...

in word, using edit & replace, i was able to make this work and then import easily into access. but since i get many of these files a day, it is not practical to first make the changes in word.

i am trying to import a txt file into access. normally i don't have a problem with importing. but this file is strange. there are 2 or 3 or 4 rows for each record. basically each record starts with the same digit - no other row begins with that digit, but depending on how many and which...

i need the form to requery so i can get the appropriate background colors - showing that the member has been dealt with today. perhaps i could save the record, but how could i code to change the color of the background?

i have a datasheet. when the user double clicks [member number] field, a new form opens so that user can enter details. after the user enters details, the [details date] field in the datasheet is updated and the background color of some fields in the datasheet is changed. to show these changes...

i changed the setfocus line but still the focus (blinking cursor) is on the member number in the datasheet

thanks, but the users asked me not to have a close button. they prefer to have it the way i have it set up- when they go to the next member number in the datasheet the details form closes.

i have a datasheet. when the user doubleclicks on the member number, another form opens where the user can enter details about the member. when the user goes to the next member number on the datasheet, the detail form closes. when she double clicks the member number, it opens with the second...

i have a datasheet and a separate form. basically, the datasheet is a list of members. when i double-click one particular member, a form opens where i can select a membership status from a combobox. after the combobox is filled, the datasheet is requeried to reflect the status change. this...

thanks

i keep a table of the last time certain queries are run. the table consists of 20 fields. each field is the name of a particualr query. Each field has only one record - the date of the last time it was run. i want to get the date for a particular field (query). there really isn't a criteria. i...

i wamnt to send 1 email to the same email address. the contents of the email will be different every time. i want to send a list of all updated members. the query works fine, i want to include the query results in the email, not as an attachment.

i have a form where i enter today's date for those who are entitled to commision checks. after i enter the date for all those, i click on a button to open a report. however, the report is missing 1 person's commision - always the last entry. i imagine it is something simple. what am i doing...

how do i put the query results in the message of the email (not as an attachment)? would it be different if it was a report, and not a query? the query has only 2 fields and probably up to records. thanks

i have a form with member information and a subform for the notes. when the user opens the form, it will have the member info and the notes. i want those notes to be sorted by date descending. i know i can do that by basing the subform on a query. the problem is: i want the user to be able...

i tried that in the first place. doesn't work for me. i can't figure out why?!

here is the code, as i have it now. it works fine, it just seems so cumbersome. i want to use the IN function. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.tnyint_transaction_status = 8 Then Me.bill_date_comment1 = "balance due for failed transaction on " &...

i tried : if me.status in (8,4,10,15,20,25,30,35) then ... as i type it in, i get an error: compile error: Expected: Then or GoTo what am i doing wrong?

i want to have abutton that users click and then browse for file i found this Attachment: filefinder.zip, which is basically this: Dim OFN As OPENFILENAME On Error GoTo Err_BtnLocateImport_Click ' Set options for dialog box. With OFN .lpstrTitle = "Locate Import File" If Not...

i tried the select case. it doesn't help in this case. i have a paragraph and one of the sentences changes based on certain criteria. if the status is one of those numbers then i need sentence 1 else (if the status is not on of those numbers and) the money amts are not equal then i need...