Search results

I think I know what it is you are trying to do and hopefully can assist. First, though, the PK being called Serial# may or may not cause problems now or later ... why not use SerialNum to avoid any potential pitfalls? (I would also advise against using SerialNo to limit confusion and because...

So, let's say you have a form. On that form is a combo box and a subform. The combo box would have the option of choosing some voltage specification and the results be presented in a subform? This can be done a per table basis as you just requested but I am confused on your original post...

So what are you wanting as a result? Are you wanting to strip off the alpha-characters and leave the numeric? Are you wanting to establish primary keys and foreign keys for the tables so this doesn't happen again, and you won't have to use these fields but let Access do it's job and perform...

I haven't used this personally. My main place of work has an internal SWO tracking process which handles this for us. Sorry. -dK

For the system in question, the stakeholders involved and the learning curve - I'd guess you might get through two decompositions of the requirements (if you had them all) in 7 weeks. And this isn't even writing code yet. That is, if you could conduct the interviews and then get an executive...

Good lordy ... thank goodness someone is sharp at this hour to keep my gray matter focused on the obvious. Rabbitoh .. try: Cells(YourRow,YourColumn).Select HTH, -dK

Well ... there are two ways you can do this. Once is to set your tab order (right click on the form in design mode and select tab order). When the form opens, it will automatically highlight the 1st control in the tab order sequence. The second, as G37Sam said is to use the SetFocus method. On...

Once you get the theory down, here is my standard batch to donate to the cause for implementing MS Access ... http://www.accessmvp.com/strive4peace/ http://www.vtc.com/products/Microsof...-tutorials.htm http://fisher.osu.edu/~muhanna_1/837/MSAccess/ http://www.functionx.com/...

Hello and welcome to the forums. I assume you are wanting something along these lines. -dK

When you get the error, does it not prompt you to debug? If so, that should highlight the line of code (behind the command button) that is throwing the error. If it isn't then probably remarking out the error handling of the command button will display the prompt. -dK

But you'd rather complicate (and upsizing) the database by creating more tables with the same amount of variables? ... and creating mass duplicates of data you already have? I am not either understanding the logic or not understanding the goal(s) of the mission. You can use queries and have...

Greetings khchan3501 and welcome to the forums. The way you are executing DLookups are very unproductive and system taxing. You can preload the data into memory with the query driving the combo box and utilizing the data as I specified in post #2. It works in one area and not the other? Why...

It could ... it could mean anything, although in this context I think it meant Group 1, Group 2, etc. I used the example of "Choose Me" in the previous post instead of "Group 1". What both posters were saying though is to get some reuse, suppose you had a control that needed to be visible for...

ctl.Tag don't do anything with it - it is a reference for VBA to get the information out of the Tag property of the control. strTAGtoUse is a place holder for a string or string variable (str). So if you have set the Tag of a control to "Choose Me" and you want it to appear then on the...

Unless it is tax related. -dK

Got to thinking. Check the form properties to see if the name of your custom menu bar is in the ToolBar property. If it is not in the drop-down, then you might have to import into 2010. Like I said, I don't know for sure but you are using a product barely out of the chute. -dK

I am not sure what you mean when you say that you used a query to auto-populate the other controls. What you can do is in the AfterUpdate property of the combo box control is assign the values to the other controls. E.g., Me.txtControl1 = Me.cboComboBox.Column(1) Me.txtControl2 =...

Why not append Table 1 to Table 2 then? If not, go into Table 1's design mode, add the field and save. Then run your append query. To answer your question though, no. You could use a data definition query for the mod and then an append query. I've never tried it but you may be able to...

If it is just a one-off then you can use a make table query to do this. Then you can be selective about the mixing and matching of fields in the QBE to be used in the new table. I am not sure of the whole using combo box stuff or why you would want to do that. Now if the scenario is that you...

No, that is fine. The deal is, you can set it as an SQL statement. I am not sure off the top of my head of the loading order since you use a query. You may be able to get away with using ... Forms!frmFormName!txtControlNamewithID In the critieria of the query under the ID column (this...