Search results

Hi VBA Masters, I'm calling a stored procedure in VBA which runs for some time doing many things. Is there a return value that can be captured to know when the sproc is complete?

Hi Galaxiom, Thank you it was late when I was coding this and I used the dot (.) operator instead of the underscore (_). Much appreciated.:D

I did think of that and linked it into the Access app. The tables are mssql backend Is there something else, I should do?

Hi VBA/SQL Masters, I have the following vba script to truncate an SQL table. I keep getting a run-time error 3265 - Item not found in collection. But, I can't figure out what is wrong. Does anyone know how to fix it?:( Private Sub btnBM_Click() Dim qdef As DAO.QueryDef Set qdef =...

Hi Form Masters, I have a combo box that displays 5 columns. It is populated by a userid field that filters the number of rows none, one or more. Functioning in the usual way when you click on the down arrow of the combo box it will show the rows associated with the userid. Now, to the issue. I...

Hi MajP, I have not used Debug.Print but did find the issue. I left out a single quote '. MsgStr1 = Nz(DLookup("Proposal_id", "dbo_dm_proposal", "id_Number= '" & [Forms]![Donor_Intake_Form]![DonorAdvanceID] & "' and Proposal_Is_Active = '" & "Y" & " '"))

Hi MajP, Id's is varchar(10) and Active is char(1) so strings.

Hi Data Masters, Still working on the first issue but can anyone see what is wrong with my two condition DLookup I get the error message : Syntax error (missing operator) in query expression. But, I don't see what is wrong. Here is the code. MsgStr1 = Nz(DLookup("Proposal_id"...

Hi Form Masters: I have an issue with a subform (Grid layout). The first column is a ComboBox it has the following query for its data soruce: SELECT dbo_dm_proposal.Proposal_id, dbo_dm_proposal.Proposal_Title, Format([Target_Amt],"Currency") AS Ask_Amt, dbo_dm_proposal.Start_Date...

Hi Minty, What you said about the PK is absolutely correct it is an identity field and is never null. But, that is the issue meaning that if a user decides not to save a record the PK is the only thing saved with a black row. The main form has a lookup table that fills in Donor information if...

Hi Table Masters, I have a form connected to back end SQL 2008 R2. The PK is call GiftID and as expected is automatically inserted into the table/row when a record is being added. The problem is that if the user decides not to add a new row, I get a record with a PK that is blank. How can, I...

Hi Ridders, Just back from vacation where do, I put this code? ShowControls False, "H" In OnLoad?

Hi Code Masters, I have the following SQL function that, I would like to execute from Access vba code. Can someone give me direction. :confused: The function takes one parameter and checks the status of the code and returns active or inactive. DECLARE @ret tinyint; EXEC @ret =...

Hi Ridders, Yes, in fact the message is happening on a bit field, but I believe that, I set the default to 0, but I will check. :(

Hi Form Masters, I keep getting this Access message: The data has been changed. Another user edited this record and saved the changes ... We have all seen this before and I understand why its happening. I'm updating a table using several forms since the data is broken up into logical chunks on...

ridders, Is there an Access function that can return the position of an object on the form?

Hi ridders, What can you say about placing the objects on the form?:rolleyes: The code will only turn them on or off.

Ridders, This implementation of very cool thanks! I would like to expand on my question since it is relevant to my form. On part of my form, I have a section for payment type. Examples are Check, Cash, Credit Card, ect. Since, I did not want all of these payment methods cluttering up the form...

Mark, So, if I understand you correctly what you are suggesting is as follow: Here is the OnLoad code for my form: Me.btnMedStewForm.Visible = False Me.btnHelp.Visible = False Me.Label_TabExit.Visible = False Me.LblTextInstructions.Visible = False Me.DonorAdvanceID.SetFocus Me.btnTest.Visible...

Hi Form Masters, I have a relatively complex form that hides many things (subforms, textboxes, ect) using its OnLoad event. But, as I update or add new records the "hidden" objects remain open. Is there another event that, I could use to reset the form back to its onload state without actually...