Search results

I'm working with an Access program and a portal site that both make updates in an SQL database. If a user in the Access program is changing records in a table, and someone submits a record on the site, the site update will go through and reset whatever changes the user was making in the Access...

Below is a piece of code I'm using right now to grab a value from a table on the SQL Server. The site is on the Web Server. EDIT: Apparently it put a space between connectionstr and gs, it is correct in the actual code. I can ping the SQL Server. I can log in to the site with one of the...

Hey all. I have query we're working with that is part of a larger process. When it runs, it will show the progress bar at the bottom and it slowly progresses. The problem is about three times before it will finish, it will pop up and say something like Connection Lost/Timed Out. If you click...

Code that runs fine in A2003 in 2010 gives this error: "The format in which you are attempting to output the current object is not available." The code is a DoCmd.OutputTo acOutputQuery, "qryCompare", acSpreadsheetTypeExcel19, file name, false. At first I thought it was because the code was...

All the functions I've looked up deal with having both dates and calculating a difference. Is there way to calculate a date in the past? For example, if you need to calculate 30, 60, 90 or even 365 days back from today.

Is there a way to determine whether a user selects Yes or No on the default Access delete warning? I'm having trouble finding an answer to this anywhere.

On a subform, I have deletions enabled and a prompt if they try to delete an entry that asks if they are sure they want to delete it. The code works, but it will pop up twice when asking. Answer = MsgBox("Are you sure you want to delete this Asset History entry?", vbYesNo + vbQuestion...

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...

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 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?

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 -...

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...

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...

If I understand correctly from what I just looked up, Me.Dirty checks to see if any changes have been made. I have a form that has text boxes and combo boxes (that I've changed both) and me.dirty still comes back false. Although, the code is under Form_Unload. Would that affect if it comes...

I've found a lot of stuff for getting what's on the left side of a comma, but I'm trying to grab what's on the right side. I found the following for getting the left side: Left(Me.Employee, InStr(Me.Employee, ",") - 1) Can I do the same with Right? Using -1 (and other numbers) I still kept...

I have a piece of code that says: If IsNull(Me.lstClientInvestments.Column(8, SelectedItem)) Then EntityToPass = 0 Else For some reason though, on entries that I KNOW the value is null and should run this code it doesn't. Then it skips to this line and I get a type mismatch...