Search results

  1. D

    weird table/query/form/wte issue

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

    Table relationship and deconcatenation

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

    Table relationship and deconcatenation

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

    Electronic Tee Cards

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

    I need some help before I start

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

    Making the cursor default to a form field

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

    Making the cursor default to a form field

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

    someone pls help

    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/...
  9. D

    Electronic Tee Cards

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

    Emailing an access report as an excel sheet

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

    A difficult question (1)

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

    Automatically filling in fields with table info

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

    How to group controls on form

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

    How to group controls on form

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

    Automatically filling in fields with table info

    Unless it is tax related. -dK
  16. D

    Question Custom Menubar in Access 2010?

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

    Automatically filling in fields with table info

    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 =...
  18. D

    A difficult question (2)

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

    A difficult question (1)

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

    query for listbox criteria help

    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...
Back
Top Bottom