Search results

I have a database which I have split into two (back and front end). I have been working on it on my local machine. However, it will be going on a shared network drive where multiple users will have access to it. I have copied to database to the shared network drive and changed the linking of...

I have a simple question what I want to do is get the current directory path of where the Access database resides, how would I do this using VB? Thank you.

I have the following code which determines whether the field is blank or if there is an empty string. (see below) If IsNull(Me.myTextBox) Or Me.myTextBox = "" Then ' DO SOMETHING However, when the code runs I get the following error: "Run-time error '438' "Object doesn't support this...

I'm looking over an access form, and I'm trying to work out what this GUI control is (see attached screenshot crop of control from form). The form is locked so I can't modify the form, although when I click on the subform control and right click on it is says it is a form not a datasheet...

Hi, I have the following function. When I try and I compile it it stops at the following line "Dim itemInfo As Info" giving the following error messgae "compile error: user-define type not defined". I'm not sure what I'm doing wrong, would anyone have any suggestions? Thanks Private...

I currently have multicolumn combobox with three columns on my form. When I select a value from this combobox it automatically displays the record for the value selected in drop-down box. What I want to do is when using the navigation buttons at the bottom of the form I want the current record...

I have a combobox named ComboFindDocs, it is unbound control although it's populated by query in Row Source Type (see below): SELECT Document_Table.Document_ID, Document_Table.Document_Number FROM Document_Table ORDER BY Document_Table.Document_Number; In the combobox documents numbers are...

Hi, I have a form and when the user clicks on the save record command button it calls the Form_BeforeUpdate event function. Also, the Form_BeforeUpdate shall be called when the user presses the close button (top X button). The function checks the values entered into textboxes and comboboxes...

I have a form and when a user wishes to update/delete a record for example I have created a pop-up box asking for confirmation of the operation before it commences. I'm currently using DoCmd.RunSql("UPDATE.... , when the user clicks on yes, a new pop-up box appears which is autogenerated by...

Hi, I have the following SQL update statement, but I can't seem to get it working. Would anyone know what I'm doing wrong? DoCmd.RunSQL ("UPDATE Document_Table " & _ "SET Document_Table.Title = '" & Me.Title & "' " & _ "Document_Table.Date =...

Hi, I have a form and once a user has filled the data in he will press a button which will validate the data and checks to see if it is valid, if it deemed to be valid it will add it to a table. I therefore want to diasable any entering of data into the table unless the command button has been...

Hi, I have a query where it will return multiple records. What I want to do is loop through all the records received from the query and delete them from the specific table. I know it is a simple question, but I'm not sure about VB. I know how to deal when a query receives just one record but...