Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dixxy
  • Content: Threads
  • Order by date
  1. dixxy

    peidt

    Hello, i am having trouble with pedit. What cause line to not want to join together when using the PEDIT command? I have a bunch lines that i want to join together to create a single polyline, and it's not working. Some of them came together, but the rest won't do it. Why would this...
  2. dixxy

    opening 2 different forms from the same module

    Hello, I am wondering the following question. In my database i used the 'default' Access switchboard as start-up form. This switchboard has many buttons and menus. 2 of those open the same form in different state. example: button 1 opens form Jobs in 'Add Mode' Button 2 opens form...
  3. dixxy

    opening a form with 2 different filters

    I am trying to open a form based on 2 different criteria. I have a form [frmJobs] with a button to open [frmNewPO]. This form is an intermediate between jobs and actual purchase orders, so taht 1 job can have multiple Purchase Orders. This form will list all PO for that particular job. This...
  4. dixxy

    list box

    Hi, Is there a way to know if a user has selected something from a list box or not? If my user does not select a item in a list box i want to tell him about it and not open a form until something is selected. Can this be done? Thanks, Sylvain
  5. dixxy

    Format to 4 digit

    Hi, I am trying to have a text box show valur like this "001" ,"002", "003" without the quotations...I always want it to show 3 digits. The data type for the feild is set to text. How can i do this? Thanks, Sylvain
  6. dixxy

    Filter query based on current record

    Hello, I woull like to know how i can filter a query based on the currently selected record? I am trying to copy a record from inventory table to purchase order table, and i would like to filter it based on the currently selected record. I think i can do this with record count, but i...
  7. dixxy

    refering to a page on a tab form

    Hello, I would like to know how to refer to a specifec page on a tab form? Like this: If me.form![what_ever_condition] then me.form![tab_form_name]![page2].visible = false End if I can't seem to make this work, i cna't refer to the page on the tab form. Can this be done? Thanks...
  8. dixxy

    Filter Append quesry

    Hi everyone, I would like to know how i could filter an append query based on a current record. Here is the setup: I haqve a form (inventory) with a sub form (purchase orders). I would like my users to be able to scroll through the form, and when they find the item the want from the...
  9. dixxy

    Report and sub report

    I have a report that returns materials used for a job, inside that report is a subreport which returns offcuts for those materials. The problem i am having is, if there is no material, but there is an offcut, then the offcut does not show up, so in other words if there is no parent i get no...
  10. dixxy

    Union Query

    HEllo, I am having trrouble with a Union query. Is the recordset produced by a Union query supposed to be updateable? In other words, if i have form that is based on a Union query, can I modify a record from that recordset throught the form? Thanks, Sylvain
  11. dixxy

    Window font viewer

    Hello, I would like to know how to restore windows to the default "Windows" font viewer. I have installed ACDSee. And it associated viewing the fonts with it...it does not show it like the 'Windows font Viewer' and i would like to restore this. I tried with the file associate windows...
  12. dixxy

    Limiting users to run programs

    I was reading through this thread thread616-479080 and it seems that everybody that has gone trhough it has found the answers they were loking for, except me... the question that i still have is: How to prevent set up so that my users will only run one program, the one i decide that they...
  13. dixxy

    Access 2000/Access 2002

    I have a really weird problem. I have created form with a text box that change colors based on calculated day value (now() - entry date). All this is done with conditional format like this: Field Value between 5 and 10 background = green Field Value between 11 and 15 background = yellow...
  14. dixxy

    calculated field criteria

    Hello, I am having trouble with a calculated field. This is what I have as source for the field: ="Total " & " = " & " (" & Count([Type]) & " " & IIf(Count([Type])=1,"detail record","Jobs") & ")" What I would like it to do is add to it a little and have criteria in there. Were [type]...
  15. dixxy

    Date calculation trouble.

    Hello, I am having trouble achiving my end result. I have a form (single) with a subform (cont.) and would like to be able to cpount the number of wokdays beteewn now() and a date that is in the table (or in the form, same one)...this is the code I am trying, but it returns 0 On Error GoTo...
  16. dixxy

    Diesel Text

    Hello, I have just reinstalled AutoCad 2004 on a mew computer. I am having the following problem. Before i was using Diesel Text or something similar to give me date and time stamp on my drawings. This is what I was using: $(edtime, 0, DDDD", "DD". "MON YYYY - H:MM) Now I can't get this...
  17. dixxy

    how to pause the timer

    Hello, I would like to know if there is a way to pause the timer function in a form.. Right now I have this in the on timer event DoCmd.Requery the problem is that when i try to edit data the event fires off and I can't put in any data...i need to pause or stop the timer to ba able to add...
  18. dixxy

    Special Index

    Hello, I have come about a situation were I don't know how to resolve. We have a design software that does kitchens cabinets, and outputs code to different CNC machines. In this software there is a small module to manage offcuts. (btw. all the data in this software is stored in Access...
  19. dixxy

    Changing Index

    Hello, I have come about a situation were I don't know how to resolve. We have a design software that does kitchens cabinets, and outputs code to different CNC machines. In this software there is a small module to manage offcuts. (btw. all the data in this software is stored in Access...
  20. dixxy

    IIf and Nz problem

    I have a report with a sub subreport . Then subreport is there to calculate a certain total. then on the main report I use the value from that subreport and display it as a total in a textbox. The problem I have is that if that sub report does not have any records in it, the text box will show...

Part and Inventory Search

Back
Top