Recent content by lauerj

My database is a fairly simple one, I am working with the design master of a modest multiuser application with a number of forms which as subforms as part of a larger application. Starting today I keep getting the error message "You cannot carry out this action at the present time&quot...

My database is a fairly simple one, I am working with the design master of a modest multiuser application with a number of forms which as subforms as part of a larger application. Starting today I keep getting the error message "You cannot carry out this action at the present time&quot...

So in the access application I inherited all I am trying to do is add a few columns to a table - 'customer_notes' and access is getting all crazy on me... I am trying to add 2-3 columns to this table and have them update when the user types text into the same form that already captures...

Alright, I was able to solve my problem by using an alias in my SQL query (returning the %_hr_peak field AS PercentHourPeak). Binding the expression inside [] usually works as well but was not in this case I think because it was a calculated expression. A number of fields in this db do not...

It's an application I inherited and was hired to fix!

The vb code powering one of my forms is giving me a compile error due to my use of the '%' character in the following statement: fsubQtrDemand.Controls("textnp" + strTag).Value = rst!%_hr_peak However '%_hr_peak' is the name of the column that I need to read from...is there a easy...

I narrowed the problem down. All that have to do is switch between the Design View and Form View and it grows in size each time (usually 2-3Mb) each time I switch from one to the other. What is going on?

It's not immediately balooning in size but I have noticed a significant performance decrease. It literally takes 60 seconds to save every time I make a design change to an embedded form. I'm on a pretty good laptop computer, any ideas?

Alright I am dumb. Why does this happen though? any tips for keeping my application as light-weight as possible?

I created 2 queries and was messing around with the formatting of a few forms in my application and next thing I know it starts acting REALLY slow. When I finally closed the application, i noticed the database that was ~20Mb large when I started is now over 1.2Gb large - what could have...

Buhler......Buhler......Buhler...

OK, I was able to get my form to work and it looks good for the most part...The only problem that I am still having with is that I *cannot get default values to be populated* in any of the calculated fields (there are only about 10 of them right now). For some reason they refuse to show up even...

Sounds good, I still have a few ?'s: - is there a way I can get the cells to update without binding them to an expression? - how do I get form to display a default value? (I fill something in for the "default value" box in the cell's properties but nothing shows up...) - any idea...

In my form, the user currently enters a number (% Change in Price) which a number of values elsewhere in the form are keyed off of (Reprint Cost, Total Cost, etc). Is there a simple way where I can allow the user to instead change one of these values (e.g. Reprint Cost) and have it...