Search results

If any body is wondering the reson that my code did not work is that Me!ComboBox1.RowSourceType = "Value List" Me!ComboBox1.LimitList = True does not work in 2003 or least not for me. I removed that and it worked perfectly. Thanks S.O.S for steering me in the right direction.

After seeing your attachment I realized that I am try to creating the form in the VBA editor and you created it from the access forms. I think I know what to do now for the most part but I now I have new questions. Assumption- once user clicks on desired table name that string gets stored in...

Did not work. I don't know if this matters but when I llok at property menu for the combo box it oes not have a rowSourceType listed. It does have Row source though. I am using 2003 not 2007 if that matters. Thanks for fast repy.

This is my first time creating a combo box. I have a button that opens a form that contains the combo box. I am trying to load all the table names into the combo box. I am getting a mismatch error when I get to this line Me!ComboBox1.RowSourceType = "Value List" Here is entire code for...

Coach, We run a large number of different scenerios for comparisons and each case has multiple input files, case by case comparisons, and tables htat return calculations based on the inputs. It would be really helpful to have them grouped together becuase the database will get pretty large.

I am actually using 2003 if that makes a difference.

If I wanted to use the SENDKEYS how would I have it enter into the dialog box. I can't put it after because it does not get to that part of the code and if I put it before nothing happens.

Well, thanks anyways, I'll probably steer clear of the Sendkeys, but if you come across anything useful please post it.

I was able to find this DoCmd.RunCommand(acCmdNewGroup) but it only opens the dialog box to enter the name. I want to pass the name to it not have the user enter it. Any suggestions

Thanks. I was thinking I could try to use the Edit menu. Tell VB to go to tool bar select Edit, then New Group..., maybe.

Thanks, I don't want to import the groups. I just want to automate the process of creating a group short cut and sorting the tables into approriate group. Example: for case X five different tables will be created named X_1, X_2,... Now I want to create a group called X_tables and populated with...

Does any one know how to use vb to create group shortcuts using vb? My goal is to populate Access database with tables and create group shortcuts for sorting in one click(not including prompt for table name)

ByteMyzer, you are my hero. That worked perfectly. It was so consise that a novice like me could duplicate.

Never mind forgot INTO clause

I need to create a new table using three existing tables. Calculations are maded. I was able to use the SELECT INTO statement for two tables but can't do it for three. I keep getting syntax errors. I created the new table using query design tool and copied SQL but it would not work in VB...

Thanks for reply. I looked into that but am not that familar with VB and I wanted to return a string. I got it workinging I just made xlTmp.Visible = true

I used GetOpenFIleName() to retrive a file name but the problem is that the dialog box does not come to the front. The only way I can see it is by using ALt +Tab. How can I bring the dialog box to the topmost window. Dim xlTmp As Excel.Application Set xlTmp = New Excel.Application...