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

    Date extraction

    Hi, Any ideas on how to extract a part of a date, I need "7" form 2007, "8" from 2008, and so on. I have been using the below which has worked well until now: AnyString = DateField MyStr = Right(AnyString, 1) NewValue = MyStr While all is ok when using the date format "DD/MM"/YYYY" all the...
  2. Peps

    Blank report textboxes

    Hi, I'm afraid that I've got another question: Is there any way I can create a report that can show or hide the document data as shown below: I have a TextBox with then below Control Source: ="Doc. Number:"+[Doc] The idea is that when [Doc] TextBox (which is not visible) has a null value or...
  3. Peps

    Quick format question

    Hi There, This may be a quick question.. I've got a report in which I have a textbox that has to gater info form a few textboxes Text88 which is a text Text89 which is a number "000001" Text90 which is a text The Text box that must gather the said info is as below: =[Text88] & [Text89] &...
  4. Peps

    Multiple query report

    I’m presently going through a brain storm and would appciate some Ideas. Let’s hope that I can clearly explain myself.. I’m working on a small DB that handles the in/out of stock for which I have two Tables: [Entry] & [Dept] The [Entry] table basically has the same fields as the [Dept] table...
  5. Peps

    PRINTING BAR CODES

    Hi all, Just a quick question, does anyone know if it is possible to print bar codes from Access 2003 and how? Thanks,
  6. Peps

    Send keys acro problem - access 2003

    Hi, I've got a problem with a SendKeys {ENTER} macro. This macro has always worked smoothly, but after installing Access 2007 on the same machine (alongside Access 2003) the stated SendKeys macro has stopped working. I get an error stating: The SendKeys action requires the Utility Add-in to be...
  7. Peps

    Hyperlink warning

    I've just created a hyperlink to a from that opens a simple notepad, it's ok except for a message that I cannot get rid of: Opening "Notes.txt" Hyperlinks can be harmful to your computer and data. To protect your computer, click only those hyperlinks from trusted sources. Do you want to...
  8. Peps

    Exclude weekends and holidays

    Hi, I’ve got a DB that amongst other things creates a forwarding list for work orders that have to be submitted 2 working days in advance. The DB in question has a table called “Holidays” that contains two fields: [Holidays] which is a date/time field and [Title] which is a simple text field...
  9. Peps

    Editing query data via code

    Hi Guys, I've go a code that edits data in my [Taxi_Service] table: Function Crew3_To_Crew2() As Variant Dim db As Database Dim Table As Recordset Set db = DBEngine(0)(0) Set Table = db.OpenRecordset("Taxi_Service") Table.Edit Table("Rank_3") = Forms!Taxi_Service!Rank_2 Table("Name_3") =...
  10. Peps

    Query between values

    Hi, I'm having a bit of a brain storm I have a really easy table with only 3 fileds [Name], [From], [To]. The name filed is text, while fileds From and To are numbers. Lets say I have a couple of entrys like the ones below: Name From To John 1 20 Simon 70...
  11. Peps

    Simple Sum problem

    Hi there, How can it be that I get an input box when opening my report? I'm trying to get a sum by using =Sum([Text60]), but all I get is "Enter Parameter Value" [Text60]. The [Text60] parameter exists in on one of my reports footers, I'm unable to see what is going wrong? Can anyone throw...
  12. Peps

    Help with updating data

    Hi there, I have two tables [Deposito_Temporal_Entrada] and [Importación_DT_Salida] both tables are receiving imports from Excel. I have to be able to update the [Importación_DT_Salida] table with data from the [Deposito_Temporal_Entrada] automatically. The below SQL returns those values...
  13. Peps

    Import error handling

    Hi There, I have a table that is reciving data from Excel, there are occasions when the data imported dosent correspond to the field criterias. (text into a number fields) The problem is that My DB has stopped creating the Import Error tables and is now showing standard error msgs like: The...
  14. Peps

    Transfer Spreadsheet problem

    Hi, I have a small problem, I want to import data into a table from Excel2000. Each time I try, either via code or via a macro, I always get the error. Couldn't find installable ISAM. (Error 3170) I'm using Access97, the stange thing is that Access2000 dosent give me any problems. I reckon...
  15. Peps

    Grouping services

    We have been working with an old program that up until now administrates our taxi services. I have been given the job of implementing this utility in a multi task application I’m presently working on, this is being done Access97. I can only foresee one challenge: Although a cab can be...
  16. Peps

    Emailing query results

    Hi, does anyone know if it is at all possible to email the results of a query in the actual body text of a message by using the SendObject cmd? Peps [spineyes]
  17. Peps

    Deleting from an Unmatched Query

    I've created an Unmatched Query that works perfect, since the results from this query have to be deleted, I turned the query in question into a Delete Query. Once opened I get the following msg: Specify the table containing the records you want to delete. I'm a little stuck on so any help would...
  18. Peps

    Lazy Users

    I've got a form where, in order to print a report the user has to update a field with a user name. A messgae box hits you if this is not done. The guys I'm working with are entering "." to avoid having to enter the required name. I added a routine to prevent the entering of a single dot. but...
  19. Peps

    Not In List Message

    Hi all, Just a quick question? What's the best way to get rid of the "The text you entered isn't an item in the list" message. I've created my own msg box, but Access97 always shows it's standad msg after mine... Peps
  20. Peps

    Email results

    Hi Guys, Just a couple of quick questions, is it possible to email the results of a query (as text) using the SendObject cmd? Is there a limit to the amount of text you can send from Access97 to Outlook by using the SendObjet cmd? Peps,

Part and Inventory Search

Back
Top