Search results for query: *

Had a simple way to pick the date with this code. Private Sub cboEndDate_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) ocxCalendar.Visible = False ocxCalendarEnd.Value = Date ocxCalendarEnd.Visible = True End Sub Calender popped up, you select the date and you are...

Okay I built is database to keep track of quotes so when the user clicks a button it gets the next quote number. Had my form bound to the table but when the user hit cancel of course the data was put onto the table with they picked. Thus I unbound the form and use expression like so. rec.new...

Private Sub cmdExport_Click() Dim excelobj As New Excel.Application excelobj.Visible = True With excelobj 'Add a workbook. .Workbooks.Add ChDir "C:\LCD\Programming" .Workbooks.Open FileName:="C:\LCD\Programming\PROJECT.XLS" .Cells(1, 2).Value = Me!cboName .Cells(2...

My form "frmNewContact" has a VBA code on open. Dim varX As Variant varX = DLookup("[ID]", "[tblCustomer List]", "[Bill-To Name] =" _ & Forms![frmNewContact]!txtMYCustomer) In the table "tblCustomer List" ID is the primary key field and "Bill-to Name" is the text field. This is the...

I am having trouble moving label and text boxes. When my form opens I want certain labels to move around according to value given my the users but it does not work. So I tried a simple test on open form I type this out label1.top = 0.5 label2.top = 1.5 but the only thing that happens is the...

Found this code to export Access form data to excel. I added a few lines to open an existing excel file, the probelm being it only works once; excel is left in the computer memory even after clsoing excel and cannot get it to clear. My second question is how do you goto a specfic sheet in excel...

I want to export specfic data to access to an excel file template. For example customer name is ABC Corp with a click want to insert this info in an excel file in cell b3. Any suggestions?

Need help on the VB side of things. What I have is a text box on my form name txtBegin and another txtEnd, they are combine in a text box called txtCombine. The txtCombine is actually the name of a report to be opened there are different combo that user can choice from. Having trouble getting VB...

have a customer form listing of course the companys I deal with, so what I what to do is take the customer listing as a subform and when I click on a company it changes a label caption in the main form. Cannot seem to get the code right can anyone help? Thanks

Have a problem requery a subform from another subform. Have a form with two subform attached "Alpha" and "Beta", the users selections a button from subform alpha but beta is not refresh the new new information. If I make a button to refresh the subform beta then the information is there. I...

There is no way in access that I can tell to put in a user sketch form area where as they can draw a picture if need be. Thus my idea was to allow the user to attach files to the user form and have access save the path name. I need help working this out. How do I do an user interface on the form...

On one computer the text that equals the date is fine but when I start the database on another computer it shows up as #name? does everyone have a clue why this is happening and how to fix. thanks.

I have inserted a picture into my spreadsheet but it does not display on the screen or in the print preview. Under Options>View - Objects I have Show All checked and have been on Microsoft UNhelpful site with no prevail. Even in Word if I scroll the picture disappears. Does anyone know how to...

My question just needs a simple code but have not found it yet, made my form with two tabs "A" and "B" but instead of clicking on the tabs what to click a button to go to the next tab. what I am trying to do is have a "next" button to control going to the next page tab, so this way can force the...

When I double click my block the EAE (Enhanced Attribute Editor) appears, okay no problem here. When I type DDEDIT then click the same block it use to bring up the old editor (which is what I want), but some how DDEDIT now brings up the EAE. nnnnoooooooooo. How do I fix this problem? Thanks.

I am running Acad2000 on Windows Xp platform some how during the day my qleader mtext stop coming up, yesterday it worked fine. In the leader settings Mtext is clicked on. When the line "enter first line of annotation text <mtext>:" appears can enter text here fine, but normally is I hit enter...

How do I pass variables from one form to the next? Thanks

Having trouble getting distance between to known points in my VBA program. This is the line I wrote but it does not seem to like it. Dim Pt3(2) as double Dim Pt5(2) as double Dim LenD as double Pt3(0) = 0#: Pt3(1) = 0#: Pt3(2) = 0# Pt5(0) = 2#: Pt5(1) = 4#: Pt5(2) = 0# LenD =...

Can anyone tell and show me an example of how to return the tabindex ID. Made a 5 optionbutton inside a frame but do not know where to go from here. Using VisualBasic in AutoCad so not sure how to create a control array. On my user form (userform1) all I do is click on the optionbutton icon in...

Cna anyone tell and show me an example of how to return the tabindex ID. Made a 5 optionbutton inside a frame but do not know where to go from here. Thanks.