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 wOOdy-Soft 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: RobPotts
  • Content: Threads
  • Order by date
  1. RobPotts

    jetdirect ex plus, HP LJ1100, Netgear router. HELP

    Hi, I'm a beginner to Linux and to networking, however I've aquired an old Jetdirect ex plus, and want to network it through my Netgear DG834GT router, so I can print from my desktop duel boot Ubunto/XP (wired), Laptop testing other linux distros (wired) and 2 work laptops running XP...
  2. RobPotts

    e-mail signature in tool bar Outlook 2003

    Hi, I've just had outlook 2003 out on my machine and I can no longer find the signature picker in the toolbars when I'm going to send a message. I have 2 signatrues and don't use them all the time, and I'd liek to have dropdown on my tool bar which allows me to choose which I want to use for a...
  3. RobPotts

    Text Field Format

    Hi, On a form I have an autonumber, which I display with leading zeros, e.g. 001, 002 etc. I then want to insert this info into a text field, so I end up with IS\001, IS\002 etc. I have the following code in an after update Me.SOP_Number = "IS\" & Me.Autonumber however this drops my leading...
  4. RobPotts

    Electronic Signatures

    Hi, I currently have a form which I want to add e-signatures to, is this possible? When I say e-signatures what I want is for: a user enters a date in a field, this causes a popup to ask for the user to enter their user name and password. The user enters this and if it matches the user...
  5. RobPotts

    send to dest top, & open screensaver

    Hi, I want to add two buttons to a form, one which minimizes all windows and one which starts the screen saver. Can anybody help? Rob! [Bigcheeks] Process and Procedure are the last hiding place of people without the wit and wisdom to do their job properly.
  6. RobPotts

    Hidden text issue

    Hi, I have some hidden text in a template which is causing me problems. I've set up three styles 1 Title [COLOR=red]Hidden text[/color Red] 1.1 steps The hidden text gives a few instructions to novice users of the template. However when the hiiden text is hidden the 1.1 steps seems to...
  7. RobPotts

    Force Page break on complete group

    Hi, I have a report which is grouped. A page may have several groups, which I'm OK with, but I don't want half a group on one page and half on the next. I want only full groups on a page. Is this possible Thanks in advance Rob! [Bigcheeks] Process and Procedure are the last hiding place of...
  8. RobPotts

    Background colour on a crosstab report

    Hi, I have a report based on the results of a crosstab query, which uses the following code to display the information: Private Sub Report_Open(Cancel As Integer) ' You didn't know how many columns, or what ' their names would be, until now. ' Fill in the label captions, ' and...
  9. RobPotts

    ields of a table as header

    Hi, I've a table of SOPs which is linked to a table of (Many) names, which also contains a tick box if training is required. I want to creat a report where the row headers are the names and the columns are the SOP numbers. Name 1 Name 2 Name 3 ect. SOP1 Yes...
  10. RobPotts

    If or then problem

    Hi, I'm not that great at code but I'm stumped with this and have no idea whats wrong. I Have a report which on the on open command I've got the following code If Me.EstablishmentSelect = "Other" Or Not IsNull(Me.EstablishmentSelect) Then Me.EstablishmentSelect.Visible = False...
  11. RobPotts

    Assign a number to all records in a field

    Hi, I'm importing a table from excel, which becomes a many part of a query. In order for this to happen however I need to assign the RecallID to each of the records in the import. The table that get generated as part of the field is called TblRecallImport The Feild I want to populate the...
  12. RobPotts

    Copy data from a form when its there

    Hi, What I'm trying to do is when I enter a item number in my form (frmNewSpecs) I want a Form to Open (FrmOldSpecs) which has the last lot of specs for that item number which runs from a query (I can do this bit OK), then I want to copy these enteries to FrmNewSpecs. I can do this when there...
  13. RobPotts

    Recordset not updatable - One PC only

    Hi all, I have an unusual issue with a database here. I'm not sure about all the ins and outs of the database yet but a form which runs off a query cannot be updated by anybody logging on to a certain PC. However the form works on everybody elses PC's. The PC says recordset not updatable in...
  14. RobPotts

    Combobox stopped working

    Hi, I've got a combobox of a for which looks up data from a table and add the ID value to the underlying table on the form. This has been working fine for aout six month, and just recently it seems to have stopped working. The form is based on a table which has several feilds including one...
  15. RobPotts

    Trouble Using the ShellExecute API Code

    Hi I found a link to the following code, which I believe will open a file in its associated application, I may be completely off the mark here, and please tell me if I am. But what i want to do is on the press of a button on a form the File whoes location is in a field on the form...
  16. RobPotts

    Loop through a memo field, extract and past in new field

    Hi, I have a memo field Called PDRDetails in a TblDefects, this has loads of info I want to extract and put in there own individual fields onthe table. The memo text looks like: Info, info, info Initiator:= Mr Fred Bloggs Job Role:= Dancer Defect:= Small Apples etc, etc What I want is some...
  17. RobPotts

    Prevent Action

    Hi, I've got a form (FrmAddNewMaster) which has a continuous subform (FrmProdCodes). On this subform is a tick box (ToBeUsed). On the Main form I have a button which runs a sereis of queries. What I would like is that when the button on the main form is pressed it checks all the records on...
  18. RobPotts

    Sending e-mail function

    Hi, I've got the following code [Code]Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook = appOutLook.CreateItem(olMailItem) With MailOutLook .To =...
  19. RobPotts

    Open a new DB from Current DB

    Hello, I'm sure this has been covered before but the search fuction is down. Is there some code which I can assign to a button on a menu which will open another DB. Both databases are secured and are controlled by the same MDW. So I don't want to have retype the username and password in...
  20. RobPotts

    Linked Tables Specifying Drives

    Hi, I've split my 2K database and I'm now having a bit of difficulty linking the tables. This is because on my computer the drive location is specified by a letter, which is different on other peoples computers. Is there a way to specify the full path in the linked refernce instead of just...

Part and Inventory Search

Back
Top