Search results

OK, thanks for the replies - for some reason I wasn't notified even though I have it flagged for instant notification... I hadn't realized that I shouldn't use auto-number for an index...I'll try changing that.

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...

Interesting...mine seems to work without the trim. Not being an "expert" on Access - not in the slightest - I can't say why your solution is different. Using a string var should act the same in both cases...My best guess is that our text boxes may be set up slightly different. Is there a default...

After looking at this a bit more, I realized it could be done easier. [code] Dim defaultStr As String Dim currStr As String defaultStr = "C:\BowlPhotos\Thumbs\NoBowltmb.jpg" currStr = Me.Text48.Value Me.Image58.Picture = defaultStr If Not Dir(currStr, vbDirectory) = currStr Then...

OK, that helped. I tried the following: [code] Dim nullStr As String Dim defaultStr As String Dim currStr As String nullStr = "c:\BowlPhotos\Thumbs\tmb.jpg" defaultStr = "C:\BowlPhotos\Thumbs\NoBowltmb.jpg" currStr = Me.Text48.Value Me.Image58.Picture = nullStr If Not Dir(currStr...

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...

Thanks for the response. I could use the Replace() function - but that replaces the characters in the table as well...something I don't want to do. I'll take a shot at using VBA to make the changes, not my best suit but I'll play with it a bit & see what happens. Thanks.

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...

Yes, it is already the default - and everything else goes to it. Just these links go to IE.

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?

And that works just fine - thanks again. And just in time for me to test with 3 new bowls done today! :cool: Another one of those "I shoulda seen that one!" lessons...:rolleyes: And I know they should be, but both tables are pretty large and it would probably be a lot of work to redo them...

Wayne, Another question - given the current code: Me.SpeciesSelected = Nz(DMax("Right([txtWoodIDcode], 3)", _ "tblSplintersWoodInventory", _ "[txtWoodIDcode] Like '" & Me.cboSpeciesSelect & Format(Date, "yy") & ":" & "*'"), 0) + 1 How...

Perfect! I really appreciate the help I get on this forum - from you, fugifox, Oldsoftboss, The_Doc_Man and others. Helped me move from a total :confused: newbe to a focused :cool: newbe... 'Tis good company I find... Stephen

Fugifox, many thanks for your advice - as you can see, Wayne's solution was quite easier than what either of us were heading for, but I appreciate the time and help. It cleared up some questions I've had on queries using VBA - so will come in handy in the future. Again, thanks for the help...

Wayne - that worked just great, thanks for the solution. That's just what I need - and simple to plant back into the table with the rest of the data for the new record. I don't know why it didn't occur to me that the last in the current year would also be the last in the entire species - too...

Wayne - yes, I do have them in a combined field, which is my primary key for the table. I had originally wanted to have a 3 field key - just as you suggest - but was strongly advised not to do so as it could be difficult to maintain properly and could be more trouble than it was worth. I now...

OK, thanks for this - I entered this in the following code: Private Sub cboSpeciesSelect_Click() Dim db As DAO.Database Dim seq As DAO.QueryDef Dim strSpecies As String Dim Str As String Dim strSQL As String Set db = CurrentDb strSpecies = Me.cboSpeciesSelect.Value & Right(DatePart("yyyy"...

OK, now I am unsure of what you told me before. When you offered the code: species = left(txtWoodIDcode,instr(txtWoodIDcode,":")), I thought that was the same as I get already from the combobox when I select the species and then append on the 2 digit year, plus a ":". That is what I have in my...

Nope - that gets a runtime error 2465 (Access cannot find the field "|" referred to in your expression). What I don't understand is that, in the examples of DCount I've seen, the criteria is shown as "string of text" for searching for a matching string in the table. And I am beginning to...

Yes that's it exactly - except that the 05 & 06 sequences are over and I am now using 07. I should have changed them all to 07 to keep it more apparent what I was doing, but in this example, the next piece of Elm - purchased in 2007 - would be Ash07:001, and the first piece of Maple for this...