Search results

hi i want to run a stored proc on one of our servers but the proc can take a while to run. It means that the access db can't be used until it completes. I'd like to fire it from vba but then release the access db and just have it running on the server so the user can go on using the access db...

hi i'm trying to use old value on an after update event so i can create an audit of changes. However, the value i'm getting is always the new changed value. do i need to get the value in another event? the control is a bound field to an sql table. thanks :banghead:

hi i am calling a stored proc and passing some params (sql). i need to loop through the execute a few times though before i kill the connection. i getting an error saying there are too many params on the second run through. What i need is to clear the param list once it's executed once. is...

Hi i need to provide a customer with an entry form to create media events. Is it possible to give them an access db where they can a) create an event and submit the details to my onsite sql db b) view/edit existing events Thanks

Hi i've had this a few times now so it's a real pain. Access 2010. one of the forms i load into a navigation form is in datasheet view and some vba re-sizes all the columns as it loads in. However, this then means that when i try to navigate away to another form i always get prompted whether...

Hi i'm trying to connect to a table valued function on sql (2005) but keep getting the following error: argument are of the wrong type, are out of acceptable range, or in conflict with one another here's the code Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Set cnn = New...

Hi i have a textbox which i want to use to search for entries in a listbox. There are 2 buttons. Search Up & Search Down. When the user searches down it should find the first entry with matching text (InStr). If the search down button is clicked again it should find the next entry. This is...

Hi not sure if this is possible but thought i'd ask. I have a PDF viewer on a form which i load pdf's into via a listbox selection. The listbox source is from pdf's in a folder. When the pdf opens in the viewer i get all the adobe menu options i.e. save, zoom, sign, comment etc. i want to be...

hi i have a form in a navigation subform (access 2010) which i want to go to a new record on load. I don't want to enable the data entry feature as i can't cycle other records?? I've come across this... Private Sub Form_Open(Cancel As Integer) DoCmd.GoToRecord acDataForm, Me.Name...

hi i'm trying to go to a record in a form based on the selected record of a subform. both form are in a navigation form and i get an error when i try to run... DoCmd.GoToRecord acDataForm, "frm_PO_employee", acGoTo, Me.CurrentRecord the error is The object 'frm_PO_employee' isn't open thanks

hi i have a form which is a list of subjects. i want to select a record in the form which then filters another form. is there a way to move to the record on the second form without using form.Filter?? i want to be able to cycle through all the other records on the second form which isn't...

i have a relationship between a subject version (1) table and a subject cover (2) table. 1 = subject/version 2 = people trained in subject/version the join is a composite on subjectCode and versionNo. my main form is from table 1. i then added a subform to 2. the parent child is set up as...

hi i am creating a training db where people can be trained against roles. a role has a version no. my question is would i create a role table and create a new record for each time a role is issued a new version. or do i create a new table of versions where i store the role id and version id...

Hi i'm trying to export a query but am getting the following error : You selected more records than can be copied onto the Clipboard at one time. Divide the records into two or more groups, and then copy and paste one group at a time. The maximum number of records you can paste at one time is...

Hi i have a subform which is linked to a people table. when i start entering a new record sometimes i want to exit without saveing but when i click of the record i get an error message .... The Microsoft Access database engine cannot find a record in the table [TableName] with key matching...

hi i filter a form based on a selection in another form. problem is when i go back to the filtered form i can no longer cycle through records. only one record is available (the filtered) or i can add a new record. is there a way to select the record and also still be able to cycle through the...

Hi i'm trying to use this... for i = i to myForm.myList.listcount -1 If myForm.myList.Column(1, i) = myValueThen myForm.myList.Selected(i) = True End If next ...to select some items in a listbox. I've had this work on another list where the...

hi i'm using mystring = replace(mystring, aValue, "") to replace duplicates in a string used to build an sql string. i.e. i could have... 1,2,201,55,202,3,40,55, 555, 22, 222, 22 so if i use the replace on the 22 it SHOULD only replace the other 22. whats happening is its replacing the...

hi i have a table which contains report definitions. rpt_id, rpt_name, rpt_col1, rpt_col2, rpt_col3, ..... (there is some other stuff) so a cell in rpt_col1 will have maybe account numbers stored in a string in, so: 5001, 5002, 5003 i want to be able to load in a report def so i need to set...

Hi i have an multi-select (extended) value list listbox which i want to be able to remove multiple items from using a button. this code removes the first selected item but then deselects every other selected item so nothing else is removed. can someone advise what i'm doing wrong? 'loops...