Search results

For counting, you can add two expressions to your query. Both are "If" statements that will return 1 or 0 depending on if this is an original drawing or revision. Not sure on the logic you will need to differentiate. You would then have a sum in your group footer for each consultant. This...

Vouchers should be a single table, not one per year. You would store the date in your table. I would only save the first and last name in this table if you have a regulatory reason to. If not, pull from the Veteran Data Table. If you DO have a regulatory reason, make sure you've got the...

From what I've heard Germany may have a much better solution that just "socialize". You can rely on the public healthcare system if you wish. You can also go to private clinics and have private insurance to help defer costs. Those who can and wish to use private medical providers. You still...

@Doc, If they are all sharing the same login to the machine, what stops them from sharing the same login to the program? My biggest concern for OP is him taking liability for security and not being able to make the system more secure than what major corporations already provide. Now if he...

Condolences for having to deal with the VA. Last time I tried getting an appointment was after I returned from deployment. Had 180 days support from the VA. First appointment for allergies was after the end of my benefits.

So long as you are using ACCESS on a windows machine, you should be able to get the current UserName for the user logged in to the machine. https://www.access-programmers.co.uk/forums/threads/ms-access-username-displayed-on-textbox-field.324611/ This would allow you to have the OS handle login...

From your description this shouldn't be a table but a query. You would sum the underlying journal entries for the debit/credit accounts for each entry, broken out by period based on the date of the entry. Your pivotquery would then run off the query of journal entries and you don't need to...

Are the fields bound or unbound on the form?

Could be a corrupted form. If Gasman's suggestion doesn't work, I'd suggest recreating. When you do, I'd also look at your data source to figure out what EXPR1011 is. That looks like it is referencing something that no longer exists and should be cleared out also. Separate item you may want to...

I'm not so worried about the human form robots. They inherit most human limitations. I'd be far more worried about some state of the art 1980's tech I'd read about. Powered mounts originally designed for remote operation of telescopes. Can be controlled from any where in the world. Designed for...

Anyone receive notice of where the wake for DickyP will be held? Heard it will definitely be closed casket!

@nectorch, Why do you have hard coded values being returned in a query for a combobox? 0 AS RRP, 0.16 AS VatRate, If these are default values, just include them where they are used OR look them up from a config file. Having multiple instances created does nothing to help you.

I think your off the Mark with this. I'm the OTHER "Mark K". Couldn't get the 2nd "K" so went with an underscore....

I can see several uses for this information. Tracking "Used" to understand why all of your WD40 is gone by the end of the week, trying to justify getting multiple cans as they are used often on different repairs, and seeing who is actually using all the WD40 to see if it makes sense. In this...

Were this me, I would store not only the registry entry, but which register they were in. This removes the need for trailing characters, prepended numbers, or any other change to data that is solved simply by saving as Register and Registry number. This will also help if you have other issues...

Old way of getting the buttons to look "Just Right" was to make image files and use those. Allowed you to "Press" a button and have it stay down (work like a toggle) or change colors or the such. If you are not getting ACCESS to generate the image you want, you can always make your own.

What are the three things people love about computers? 1) They do exactly what you tell them to 2) Never try to second guess you 3) They come with lots of documentation What are the three things people HATE about computers? 1) They do EXACTLY what you tell them to 2) NEVER try to second guess...

If you really really really want your control to look like a raised button, you can set your Me.Button.Picture =

For myself, I would create a small app that "Reads" the CSV in through a query. This will allow you to review the data and resolve any issues you have. Then create an append query that reads your properly formatted query to actually add to your table. This allows you to also create other...

At the top of your loop, you can set a variable (or several) to TRUE. Then you can use the OK / CANCEL in a msgbox to turn it off once your sure that value is correct. Other way I've done this is to write to a log file. Debugging inside a LOOP can get rather... challenging if you don't set up...