Search results for query: *

I need to create a new table using Visual Basic, and the new table must have a field with LookUp type of Combo Box. How does one use the CREATE TABLE command to create a table with a Field with the Combo Box Lookup type? Thanks, hazlehurstga

Thanks PHV! The problem was resolved when I created a workbook object and referred to that object vice using the implicit reference. Apparently Access2003 requires that I declare workbooks as objects vice using implicit statements. Thanks again

When I execute this statement ".[a1].Offset(1).CopyFromRecordset NAVICPGListTable" from code below I receive the following error: "Run-time error '430': Class does not support Automation or does not support expected interface" Does anyone know why this statement does not work in MSAcess 2003...

I need to open/retrieve a recordset with an SQL statement that usually takes quite a bit of time to complete. While the data is being retrieved, I would like to display a message via a form that basically tells the user to be patient, the action will complete in so many minutes. I am able to...

cmmrfrds, Thanks alot! I greatly appreciate you help.

Does anyone know of an automated way to verify and load references using VBA coding? Thanks

Thanks all, I'll give it a try.

Hi, I need to get input from a user by providing him with a list of options to choose from, and in the same fashion as the comboxbox feature provides. Is it possible to do this without using a form? Will the InputBox function allow work? Thanks.

Thanks for your recommendations! I'll give it a try and let you know how it turns out. hga

Understand. I apologize for not being very clear as to the problem I'm expericing but in a nut shell here's my problem: my program gathers data from existing tables using VBA coding automatically untils it reaches a point where it needs data directly from the user. At this point, I could use...

vbajock, Even without the loop, the coding described above does not let the user make a selection using the form. It simply opens the form then immediately executes the next line of coding. I need the program to wait or pause until the user has made his selection using the open form, then...

vbajock, Thanks for your reply. The loop does nothing. Its purpose is to continually loop until the user makes his selection from the form LoadCTPOC. However, as I stated, the coding as described above does not allow the user to make a selection using the form. I need to present the user...

The following MSAccess 2000 VBA coding atempts to get input from the user by opening a form so the user can select from a combo list: ProcessingForm = True DoCmd.OpenForm "ASSIGN CTPOC", , , , , acDialog Set LoadCTPOC = Forms("ASSIGN CTPOC") LoadCTPOC.Visible = True...

Actually I opened the form in design view using the following statements: DoCmd.OpenForm NewFname, acDesign Set CurForm = Forms(NewFname) CurForm.Visible = True Should the form be invisible when I add the procedure statement?

I'm receiving the following error the first time I attempt to add a line to a procedure control module : "Can't enter break mode at this time." The error dialog box asks if I want to continue or end the program. When I choose to continue, the program runs until completion but the...

VBSlammer, You are wonderful and a life saver. Thanks so much!! I hope you find employment soon if you haven't already. If you lived in or near Richmond, VA I might be able to help you find a programming job. Thanks again hazlehurstga

I'm running into problems when I try to create an OptionGroup with more than one label. The general text of my code is as follows: 'First I create a new OptionGroup control: Set ctlText = CreateControl(CurForm.Name, acOptionGroup, acDetail, "", "", 1440, 1440) 'Then I add...

Thanks CJ, it worked like a charm!!

Hi, Is there a built-in function available in MS VBA that will provide the LogonID of a user connected to a WIN 2000/NT network? Thank you.