Search results for query: *

I'd like the ability to view an Excel Spreadsheet in an Access Form - Using a field on the form to indicate the filename of the xl Document.. Is this possible? If so, How?

Is it possible to view a PDF File in a form? If so can someone give em some guidance.. I tried inserting the acrobat reader activex component on a form but I cant figure out how to load a file into it. thanks in advance Steve

I'd like to have some code that can see an existing and open excel document, go to pre-named cells and retrieve the data to then be put into an access table. I want to do this from Access.. I know how to send the data to the tables. I just need to know how to get access to see the open excel...

Can anyone direct me in how I can store a matrix of 12 Insertion points. Currently Im doing the Following Dim IP (12, 0 to 2) as Double IP(1, 0) = 21.25: IP(1, 1) = 23.5: IP(1, 2) = 0 IP(2, 0) = 23.625: IP(2, 1) = 23.5: IP(2, 2) = 0 IP(3, 0) = 26: IP(3, 1) = 23.5: IP(3, 2) = 0 IP(4, 0) = 21.25...

Can anyone provide some code on how to connect ACCESS TO AUTOCAD? Specifically I need to Insert a block in a drawing from an access form.

Could anyone provide some basic code from access vba on inserting a block? Im having trouble understanding how to gain access to the Autocad enviornment from ACCESS. Im assuming that Autocad will be running in the background, and I just want to call the current drawing, and simply place a...

I have a series of events happing in some code and as each one completes Id like a Progress bar to grow.. Ive made a new form with the bar and I call it up in the fist line of code (userform.show), at each place in the code I want the bar to grow I simply call it (userform.progressbar.width =...

Im trying to copy files in Excel and I keep getting Access Denied to the Files.. I dont have them open else where so Im confused why I'd be getting this.. Is there a work around?

How Do I set a Cell Value in an Excel Worksheet to a VBA Variable that is accessable to all my code in a workbook?

is it possible to have one worksheet cell list the name of a different worksheet tab name?

I have multiple tabs in a excel workbook - each with a list of parts (bill of materials) within it.. The sheet name is the Assembly name ie. Desk1, Desk2..etc. - how can I identify on one sheet all the different parts within each desk while totalling the values for common parts in the tabs...

I have a query that the criteria references a list box using multi-select. No entries in the query appear, when I switch the list box to single or non-multiselect, it works fine... Can I select more that one item in a listbox and use the muliple values in a query??

Why Would I Get This Error? Help Appreciated Thanks

Im running this series of code, excel starts and quits as expected, athough its process remains in memory. Am I not closing it out properly? Please help! Dim db As DAO.Database Dim rs As DAO.Recordset Dim xlApp As Object Dim path As String Dim objXl As Excel.Application Dim objWkb As...

can Anyone help with the SQL code I would need to select the following in a DAO recordset: A. designer = me.designer B. Status = "IN" and my trouble... C. TimeStamp = date() and ANY TIME. Timestamp Field is stored with Date AND time, Im searching for the date in that field only.

I have 5 records that match this criteria, yet recordcount always reports 1.... Anyone?? Thanks in advance Code: Dim db As DAO.Database Dim rs As DAO.Recordset Dim sql As String Dim RecordCount As Integer EndDate = Now() sql = "SELECT * FROM tblShopRawTime WHERE [current] = " & True Set db =...

I have a basic time keeping access application, I need it to do certain tasks automatically at a specified time of day. Can access monitor the system clock and run a command at say..11:45AM Each Day?

I have a list box that is populated by a query but will always have just one value, Is there a way to Select without clicking it, using VBA?

is there a way to take a long string, for example, "http://www.fedex.com/cgi-bin/tracking?action=track&language=english&last_action=alttrack&ascend_header=1&cntry_code=us&initial=x&mps=y&tracknumbers=" & Form_Carrier.ReferenceNumber And Have it appear as "CLICK HERE" in an email im creating in...

I get this when opening up a form, I have no clue why. Any Ideas? ps. vb editor doesnt catch the error.