Search results

My question is: How am I able to access an embedded PDF through VBA, so that I may use the following code (working): Dim WshShell As Object Dim X As Object Set WshShell = CreateObject("Wscript.Shell") WshShell.Run "Acrobat.exe \\shareddrive\Database\PAY.pdf" ' delay to let...

Evening all, I could really use some expertise on the query below. It selects matches between two days (3 sets of two dates actually, depending on if the next set is empty or not); however, I get a syntax error in query expression when i open the form and it doesn't seems to work at all. Any...

Zomg Another date question! (PICS Included) Hey guys, I've hit a bit of a brick wall, so I'm here asking the guru's of code what to do. The code below represents three sql queries that are exectuted on button push. One query is for students arriving, they are paid their initial paycheck...

Well I've hit another brick wall. I can't seem to get the following code to work. Private Sub Command112_Click() 'Print customer slip for current customer. Dim appWord As Word.Application Dim doc As Word.Document Dim docdoc As String docdoc = Application.CurrentProject.Path docdoc = docdoc +...

Hey guys, This is my first time posting in this particular section of the forums. I'm trying to work within an access database that has three text boxes and a listbox. The three textboxes contain dates. The contents of the listbox should be generated from the following query: strSQL2 = "...

Private Sub Form_Current() Dim todaydate As Date Dim masl1 As Date Dim masl2 As Date Dim masl3 As Date todaydate = Date masl1 = gradONE.Value masl2 = gradTWO.Value masl3 = gradTHR.Value If IsEmpty(masl1) Then masl1 = todaydate - 100 Else todaydate = Date If IsEmpty(masl2) Then masl2 =...

It's me again, with what should be a simple problem. Using the following code, I'm trying to compare a drop down combobox value list (January, February, etc...) with a date in the database ( 1/24/2011 for example). The records that meet the requirements are then listed in a listbox, by case...

Hello again, I'm back for another learning experience. I've been programming with VBA for a few months now, and have hit another wall in my learning process. The file I've attached is supposed to do a number of things. It's supposed to take a number of fields from a number of tables and...

Evening all, The VBA/Access question of the day is: Is there a way to get VBA to automatically populate fields with "Undefined" or "Unknown" or "N/A" when those fields do not contain any data. I really don't want to have to NULL define every single field individually or rename the fields and...

It's me again with another relatively simple access issue. I have a button that is set to delete a record, then refresh the list of records in a combobox; however, for some odd reason it takes two or three attempts to delete the actual record because it keeps showing up, and when it does delete...

Hi, I'm relatively new to VBA, and MS Access in general; however, I am very interested in learning absolutely everything I can about this application and its uses. I have two questions in particular that I cannot find detailed information for. From a command button in ms access, how does one...

The code below is used in MS Access. The listbox mentioned below is drawn from a table. The command button is supposed to update another column in that table based on the items listed in the listbox. To illustrate this, it's used for inspections. Other functions in the program generate a...