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 Wanet Telecoms Ltd 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. DiamondDust

    Query Field Names

    Can someone please help me query the field names in a table vise querying the actual data. Thanks in advance.
  2. DiamondDust

    Create Table SQL

    Do you know how to create a table with on of the fields being an sequential autonumber. Thanks
  3. DiamondDust

    Data type issue

    I am trying to use a variable in an if statement expression. For example: If dcriteria Then end if dcriteria is equal to a field value which is of type memo. in the field is criteria I want to use for the if statement. For example: dcode >= "80000" And...
  4. DiamondDust

    Easy Access Table Size Question?

    How many records can an Access table hold? and how big can an Access DB get without bugging out? Thank you,
  5. DiamondDust

    SendObject Question (Email)

    Hi, I want to use Microsoft Access to send a file through Outlook, but I don't want it to be generated through and access table or query. For example I have a file called file.pdf in the C:\ drive I just want to automate some system to send that specific file, totally not associated with...
  6. DiamondDust

    SendObject Question (Email)

    I want to the message text to have line breaks. For example, in the Message Text it Reads "Program Managers," I want to start a new line with "Please update your...". I basically do not want the whole message to word wrap. DoCmd.SendObject , "", "&quot...
  7. DiamondDust

    Help, Date/Time Stamp on a Network DB

    I have a DB on a network were the tables are linked to a backend and the frontend is all Access. There is a report that people may view if need be. When they print the report they meaning other than me the Date shows up on the report as #Name? but on my machine the Date shows up just fine. It's...
  8. DiamondDust

    Help, Get Data from Text and the Date Format is not recognized by Acc

    I brought in data from a text file with this date format 19770127. I have to bring it in as string because Access does not read this format. Is there a way to change the data type to Date and have Access recognize that format.
  9. DiamondDust

    Help Using SQL as a backend.

    How do I link my acces Frontend Forms So that they use Queries in the SQL db rather than using queiries in the access db frontend with linked tables.
  10. DiamondDust

    Help. Microsoft Access Form, Drop Down Box

    Microsoft Access Form, Drop Down Box will now show all the values that are in my table. It stops at like the 255,666 record. There are more records that will not show up. Is this the limited number of records that will show in the drop down?

Part and Inventory Search

Back
Top