allj
Last Activity: Mar 27 '08, 03:08 AM
Joined: Sep 19 '07
Location:
-
adding data in a loop qry
Hopeful New Year:
for explanatory purposes- I am running a looped sql from two tables. One is clients and other is provider. The sql loops through the provider info entering client data. At the end of each provider my info is put in before the next loop with a different provider begins. So
With rst
If Not rst.BOF And Not rst.EOF Then
rst.MoveFirst
End If
Do Until rst.EOF
dim... -
I think I can do this with a crosstabqry. If not I will get back to you. Thanks anyway. AlanLeave a comment:
-
How to make a query that looks like a report with different groupings
Hope you had a good Thanksgiving!! I am stumped. I am trying to make a query that looks like the report with different groupings but one that is exportable to a delimited txt file. In my case a header of several fields a body of continuous records and a trailer of footer. I then need to export it to delimted txt with the separator being *. A simplified version would be like this:
The header is Mdb*x432*date*> *
The detail is a loop... -
saving values programmically to cbo
Hi
I can add values to a cbo values list by cbo.additem but when I close the form and reopen it it is gone. How do I save it to the value list? Thanks -
How do I do this???
I basically want to set up an 837 claim file and need to make a qry for export to a delimited file. It needs to include header or submitting info - detail info with claim info- and footer or closing info. It can be on one line or set up in groupings. I can run a report or form with groupings but can't export it to a delimited file. Any help is greatly appreciated. -
Thank you.
I continued to have syntax problems but solved the issue with the following code:
Dim ck As checkbox
Set ck = Me!BillingSelec ted
If ck = "0" Then
CurrentDb.Execu te "UPDATE billing SET [billingselected] = true WHERE [dateofsession] like( #" & Me![DateOfSession] & "#);"
Me.Recalc
CurrentDb.Execu te "UPDATE billing SET [billingselected]...Leave a comment:
-
updateqry
I have what is a complicated update qry I haven't been able to make work. I have a form that is filtered by the following qry. Me.Filter = "[dateofsession] Between forms![billingtransmit ted]![beginningdate]And forms![billingtransmit ted]![EndingDate] and [selected] = true"
FilterOn = True
Selected are claims between certain dates to be sent to various insurance companies..
Ok now I want to update all the selected records... -
thank you. Much appreciated.Leave a comment:
-
what's wrong with this sql?
I was using this for a multiselect frm with two listboxes on each side where I was able to update the selected field in one to place it in the other lstbox and then open the appropriate form by whether selected field is yes. I have been using this successfully until now. The field "insurance" is in the "insurance" table and is the primary key. I get a missing operator message.
Dim db As Database, rs As Recordset, sql As... -
I found out the whole problem was that the msword.olb file didn't copy to the office11\direct ory. Another wild goose chase!! Thanks for coming along. AlanLeave a comment:
-
OOPS! My original solution worked. The if not file file script I wrote for the bat file that puts files on the user's computer was messed up. thanks again for everyone's help. AlanLeave a comment:
-
Help!!
Honest it loaded fine. At least it did the first and only time. I get the message: function not available in expression 'Format([DOB],"mm/dd")'. Any help figuring this out is appreciated. AlanLeave a comment:
-
macro security level
Hi
When opening mde with runtime there is a foreboding warning that their may be a dangerous expression that can damage the computer. Enough to scare anyone not familiar with access. Is there a way for this to not happen with the mde install. Or if I can convince someone to open the program is there code to set the macro security to low. thanks Alan -
Thanks all. The answer to the riddle is none of the above. You have to put the openform in the autoexec macro and then all is well. If you have a form with an expression and put it in the startup it doesn't work. Does this make sense. Thanks microsoft.Leave a comment:
-
NeoPa Thanks for the advice I will try this and let you know if the user has any problems. Thanks again AlanLeave a comment:
-
Yes I downloaded this wiz. It was able to identify references within an MDE, to delete them but not add. I don't believe the referencing is the problem. NeoPa How can I find the offending expression in the mde? AlanLeave a comment:
-
I understand but with my limited experience am unsure of how to find the function call that is causing the problem. Can you please be specific about what I need to do to provide this. I looked online to figure this out so I would save you the trouble of explaining but didn't find anything. Excuse my limited experience. What should I do to provide this info? AlanLeave a comment:
-
NeoPa: Thanks for your reply
The call is within the current module. There is an animated eye that bounces on the person's birthday:
...Code:Option Compare Database Option Explicit ' flag to identify whether animation is on ' or off, used in the form custom property procedures. Private g_AnimateState As Boolean ' Form property used to set the timerInterval property. Public TimerVal As Integer
Leave a comment:
-
The error message was "the expression (Format(DATE, "mm/dd"...) has a function that MS Access can't find." This is the if statement. Remember this worked on my second computer and I registered all the references on the user's computer. I did get the wzref file and am putting it in the app(doesn't work as an addin so imported). I can delete references with the wiz but can't add any. When I try I get a message "can't add...Leave a comment:
No activity results to display
Leave a comment: