Search results

Awesome! Glad you got it to go. Good luck! -dK

Check into the Instr function, it might solve your problems. Here is is the idea except use your fields as the evaluation. Specific notes though: If substring is empty, it returns the start value. If substring is null, it returns null. If there is no match, it returns 0 to help you properly...

Stack the pictures on top of each other where you want them to appear and then use something like this in the Report Detail .... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.txtEvalControl = CorrectValue Then Me.OLERedLight.Visible = True...

Pretty much when you click the comman button for the report - have it open a form. On that form you have your combo box and any other parameters you want to use. Change the query criteria to reference the form (Forms!frmFormName!ctlControl). Then use a command button to open the report...

So you have: - 3 tables and you want to search all of the tables at the same time. - Each table has a field (the one you want to search on). That field could have 1 of 4 possible combinations: -- 120V -- 129Vcc -- 12Vcc -- 120V, 129Vcc, 12Vcc - The tables can be linked...

Potentially. It is in accordance to the level of detail that you are wanting to record. Suppose, for instance some personnel were issued some M16s with scope and others not. I don't know if this could be a potential situation in your scenario but in some of the units I served with, this was...

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...