Search results

Thx! That gives me something to research. I'm a novice at this and sometimes, it's just a matter of knowing what to look-up you know. Thanks again!

No - they need to all be blank unless I populate them and then it's selected records only. Maybe a check box that if checked automatically throws the date in. I've tried that one but it doesn't seem to save it in the table. Or button that opens a pop-up box that asks for the date I want to...

I have an invoice form that has a subform with line items in it. Each line item has a date field in the table because we partial invoice sometimes. We have a new customer that can have up to 70 line items. I'd like to somehow auto populate that field with whatever date I type in or by ticking...

We are changing our employee vacation compensation from an annual basis (every January) to an annual hire date accrual. This code is working fine... =IIf([Text208]>240,"160.00",IIf([Text208]>120,"120.00",IIf([Text208]>24,"80.00",IIf([Text208]>12,"40.00","0.00")))) [Text208] is months employed...

OOps - I copied/pasted the wrong field....I've spent too many hours on this today. Here's what is working...sort of with the round up prob.. MMaterial: Format(Int(

I figured it out...this works: Material: Format(Int(

Hi All! Thanks to all your wonderful help I am slowly but surely getting there with our new database re-write!! I'm trying to calculate a field in a query and having some syntax problems. Here's what I have.... MLabor: Format(Int(

Okay - I checked all that but am still having the same issue. Is there anything else I can check? Thanks so much!

I have a delete query that runs fine when you click it but if I set-up a macro to run it from a button on a form I get errors. Is there a better way to run it? Thanks!

Hi there - did you ever figure out your issue? I'm having the same one. :P

That is so over my head. *sigh* Where do I put that? I'm just pulling a couple fields from two table and need to export to a txt file? I usually just click external data and then txt

Pat, Thank you so much for your response! That may be my solution however, I'm not an expert access wiz. I can figure my way through it though if you can give me just a little more info. We are linked to a sql backend...does that help? How do I set the parameter values? Thanks so much for...

I'm trying to export query results to a text file and it keeps giving me a "too few" parameters error. Can anyone help?

THANK YOU! At least I have a starting point! he he

The server but the old one worked fine and I didn't change anything. UGGGGGSSS Maybe the table on the server doesn't have a unique ID eh? Should I start there?

Hello, I am trying to redo some major sections of our database however, I am completely self taught and we just switched to a sql backend so it's not necessarily easy for me. I made a copy of the old database and went to town on the new one. I have a macro that runs a query that deletes all of...

It worked!!!!!!!!!!!!!!!!! Ty!!!!!!!!!!!!!!!!!!!!!! You rock!!!!!!!!!!!!!

Ah - the problem with that is different lines have different mark-ups depending on the vendor or possibly none if it's ours. So.....query??

I'm not sure I understand. I'm self taught and only mess with the database every few years so I forget how I figure out how to do something. Do you mean I need to do the calculation in a query then total the field? Thanks so much for your patience and help!

Hello all, I have a form with a Text Box in the detail (Text100) which contains the following =