Recent content by Splinters

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