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!

  • Congratulations Mike Lewis 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: *

  1. Dibblet

    Copying a record but changing certain values

    I hold information on a table about cartain jobs i.e. customerID, delivery date etc. Each job has a JobID. This table is called JOBS it is displayed on a form called JOBBOOK. On this job form there is a subform containing all processes required for this job. This information is held in a...
  2. Dibblet

    connecting to the network but not getting internet connection

    I have a Menotr WL-R4RII wireless router. I have it connected to a Motorola Surfboard Cable modem. My computer will pick up and connect to the router no problems and there is a strong signal. I cannot receive any internet through it though can some ome talk me through sorting this out?
  3. Dibblet

    Corrupt Record

    Yes, everytime I try to compact and repair the database access crashes.
  4. Dibblet

    Corrupt Record

    Hello, I have found a record in one of the tables of my company's database that has somehow become corrupt. When viewed using table view the record shows random characters and when viewed from the form its related to the field are filled with chinese characters and the autonumber field displays...
  5. Dibblet

    Finding an open form to run report from

    Hello all, I'm trying to open a report that is dependent on an [enquiry_id] field as to which record is displayed. The report opens from two different forms. The query running the report selects the [enquiry_id] corresponding to that displayed in the form. I am unable to find a way to run the...
  6. Dibblet

    Formatting message box

    It's a bit of a long way round and I'm not sure if it's particularly correct for your requirements but a simple fix would be to produce a form that pops up instead if you remove all the toolbars etc. it is much more easy to change is appearence.
  7. Dibblet

    Blind Double Entry?

    Have you tried settign an event 'onlostfocus' so that the visibility of the box is hidden once it is entered. For the onlostfocus event procedure try- Forms![Form Name].[Text box name].Visible = False I'm sure it's just one way to skin the proverbial cat, but hope it helps!
  8. Dibblet

    Combo from multiple queries

    I am trying to develop a form that has a row source from two different queries or by having one query and the rest listed. Can any one tell me how I would set up the row source to achieve this?
  9. Dibblet

    Hyperlink Warnings

    Hi I have the following code for a button in my database - Application.FollowHyperlink "R:/File Cabinet/", , True When I click the button I am presented with two warning that the page I am about to open may contain viruses. I don't want these warnings to come up. I have tried turning...
  10. Dibblet

    Barcode Data Entry

    If it has been disucssed previously could you send me the thread for it please? I've had a look round and I cna't find anything! I can find plenty of problems for people with barcode readers but none for actually using the barcoede readers. I've decided what I really need to be able to do is...
  11. Dibblet

    Barcode Data Entry

    I work for a small maufacturing company. We have 3 computers on our shop floor, these are used keeping track of jobs and stock using our company databases. It is hoped that we will soon start to use Barcodes to track jobs and stock. We have a barcode entry system up and running but atthe...
  12. Dibblet

    Databse Structure Map

    I have been working a company on a short term contract and I am about to finish. The comapny has asked me if before I leave will I clean out the company database and create some documenttion for future developers. I have tried the documenter function but it doesn't really give me relationships...
  13. Dibblet

    Access SQl Query

    I'll tell you in several years I only implemented it a couple of weeks ago!
  14. Dibblet

    Access SQl Query

    I had a similar problem. An alternative you could try using would be - Group by month(funding_date) Since its solved its probably not important though.
  15. Dibblet

    Date inputs

    I have done. I would like the text box to have 'dd/mm/yyyy' written in it when I move to it. I would then like to to enter the date and have it appear instead of the 'dd/mm/yyyy' is it possible to do this?
  16. Dibblet

    Date inputs

    It is not clear it is a date. So I would like 'dd/mm/yyyy' to appear in the text box to prompt the user. Can this be done?
  17. Dibblet

    Date inputs

    On a form text box that contains a date I would like "dd/mm/yyyy" to appear in the text box as an input mask. How do I make this happen?
  18. Dibblet

    Making Subform visible

    Tried playing with the expression builder turns out I was using a wrong subform name and a different command line. I ended up with- [PurchaseMesh subform1].Form.Visible = True Thanks PHV
  19. Dibblet

    Making Subform visible

    I have a form containing a subform. The for is called 'purchasedetailsB' and the subform 'meshpurchaseSF'. I would like to make the subform visible or invisible depending on what a combo box displays. I have set up an if function on the combo box, but when I run it I get and error message...
  20. Dibblet

    Copying a whole record into another table

    I would like to set up a form so that when a box is checked to finalise a form it copies the new record from one table into another as new record. How can I do this? The tables don't currently have the same fields names and I could make it so they do, but is this really required?

Part and Inventory Search

Back
Top