Search results

On a subform that displays records I have record selectors enabled in case they need to delete one. Currently I have a prompt in OnDelete (I'm not sure if this event is too late to cancel) that asks do you want to delete this record. If yes, it deletes. If I click no, it does Exit_Sub but the...

I have two subforms that populate (or hide) on load on a form. For some reason, when it loads, one subform moves about half way down the page. If I refresh the subform, it will be where I have it set in the first place. I see nowhere in the code that would move the subform. When I tried to...

Fixed the issue. Upon close inspection I didn't need .Form.

I have the exact same thing happening in two places, only one of them works though. Here is the code I'm using since I only need to change the height of the subform: Forms!frmMainMenu!subfrmHome!subfrmLeadClients.Form.Height = newHeight(ClientCount) This is from the upper most level form that...

I just need it to display the account numbers, such as 525300064138.

Yeah, I've seen it before, but usually if you stretch the field it will correct itself to the original number but this doesn't seem to want to do that.

It's a double (since it was long integer and it wasn't big enough for the number). I'm tacking on the day and date - Format(Date, "MMDD") onto an account number to differintiate the original account and the interest accumulated on it. So when I assign the interest an account number, it ends up...

I've got the text box it's displaying in wide enough but it still does E+12, same in the table, no matter how far I stretch it, it will still display with 5.253999641391E+12.

I currently have large numbers in a database and when they get to a certain point it starts doing 5.253225E+12 which ends up taking up more room than if it just put the damn number. Is there anyway to prevent Access from doing this to large numbers?

Thanks man, that was it!

For conditional formatting on negative numbers, we're currently highlighting as red text. The question I have is, while I know that negative currency is denoted with parenthesis, is there anyway to apply that to a standard number? As in, is there any kind of code where I could remove the -...

Thanks for the response Pat, I figured out what my problem was. One of the fields wasn't getting set when entering the information, but I'm not 100% sure how that was keeping the record from being saved.

Hi Pat, thanks for the response. I have a Save button and a Close button. The save button checks to see if the form is Dirty, if it is I do Dirty = False. Then it reruns the queries that are the record source of the other form (which is open but not visible). At the end of all that code I...

Currently having an issue with something that was working Friday and now after replacing my SQL Server install that was having some issues, doesn't work anymore. I've tried Me.Dirty = True and DoCmd.RunCommand acCmdSaveRecord to save the record before updating some recordsources on other forms...

Quick question about Check Boxes and their default value. I have a form that pulls data from a table, one column which -1 or 0 and assigned to a check box. The problem I'm having is, it seems to populate correctly based on the current record, but if I try to add a new record, it defaults...

I have a query that populates a list box. In the query (and all other queries associated with it) I have a column set to currency with 0 decimal places. The SQL back end column these pull from is data type decimal with a scale of 0. No matter what I do though, it always shows up in the list...

I recently tried to do some work on a report that a Client requested features be added to, but when I try to open it, I am given an error that says, "Microsoft Access can't open the form frmName. It contains data that Microsoft Access doesn't recognize." Is this a database issue? I relinked...

Well I just realized that on one form, if use me.dirty after the first entry, it will save it in the table and give it an ID number. The other form, which has VERY similar code and does nearly the same thing, doesn't. In regards to your question, we use linked tables that link to an SQL...

I tried doing a Me.Dirty after you enter text into the first text box on one of the forms and I still get a Null ID for that record. Does SQL just save new records differently?

I'm currently working with a program that used to have an Access back end and is now in SQL. There is a form whose data is pulled from a table. In the one with an Access backend, whenever you create a new record, it seems to assign itself an ID automatically, no where in the code is there a...