Search results

I need some help with a strange problem in a table of date & time stamps. The table has the following fields (others left out for brevity): Name Format ----------------- intID Autonumber index dteDate Date/Time dteStart Date/Time I needed to insert some records that were...

I have a form with 2 objects: Text48 - A text box object which will have either a path to an image file, or a dummy path ("c:\BowlPhotos\Thumbs\tmb.jpg"). Image58 - An Image Object with an empty Picture field that is filled by the VB. The Text48 value is determined by the value of another...

I have a query that gives me data from a table, and I then export it as text to Excel. In Excel I do some edits, insert columns with special characters as delimiters, then copy it into a JScript data set. This all takes some time, and has a number of steps that need to be done in a certain...

I just set up a hyperlink to a web page in a form, works fine. Only problem is, it uses IE :eek:, while my normal browser is NetScape :cool:... Is this a "Microsoft Rules!" thing :rolleyes:, or can I set it to go to the browser of my choice :D?

I have tblWood, with a field txtWoodIDcode with entry's that identify a piece of wood. For example: txtWoodIDcode Ash07:001 Ash07:002 Ash07:003 Ash07:004 Elm06:001 Elm06:002 Maple05:001 Maple05:002 Maple05:003 & so forth... I have a form with a combo box that I select the first part of the...

I would like to create a unique ID number (currently the Primary Key) for a table in Access 2000. I am using 4 elements for the current manual entry, and want to automate it after I make one selection on the Combo box. The elements are: 1: The species of the wood I am entering into the...

I need to construct a form in Access that uses data from different records within the DB - 4 identical formats on one page. This will be sent to Word to print (or could this be printed directly from Access?)... Is this possible, or do I need to produce the separate sections individually and...

I am setting up a DB for my wood turning shop, and have a table for the wood, and am setting up one for the completed bowls. Table #1, tblWoodInventory, has the wood info - species, size, source, cost, etc. - and has the following superkey: {species, last 2 digits of the year purchased...

This is my first Access 2000 form & I need to add a photo of a product, the path to the photo depends on the value of the product ID field -> "C:/photos/{]product ID}.jpg. For example: Product Ash07-001 would use photo "C:/photos/Ash07-001tmb.jpg" The path needs to be generated on the fly for...