Search results

If you're just embedding an image on a form/report, put the image in the same place as the database file(s) and drop everything but the file name from the path (Access 2000-XP, I'm not sure if 97 will do this). When you relocate, it should come right up. I do this with pretty much every database...

is the file name always the same? The reason I ask is because this can be done with text files or DBF information fairly easily. You're going to want to look at the TransferText method in VB for the import... I'll be more than happy to get into the specifics, I'm doing this now (in Access...

I may have finally found a solution for those of us who would very much like to circumvent Outlook's nasty little problem with VBA-induced emailing. I found an activex control at this site... http://axsoft.hypermart.net/ it's called "axSMTP" & it's basically an SMTP control intended for...

1. You need to create an unbound form with the fields on it that you need/want your user to be able to search by. 2. In your query, you need to limit the results of your searchable fields by referencing the fields on the unbound form you just created. For the condition of the query field, you...

to display the "totaldowntime" in hours/seconds format, you can use the following: totaldowntime: Format([uptime]-[downtime],"hh:nn") Access 2000 converts this to "Short Time" when I run it, but you can also add seconds if you need to go that specific: totaldowntime...

Never tried it personally, but there are several options for converting Palm Database info to/from Access: http://www.ddhsoftware.com/handbase.html http://www.consult-us.cc/html/handjet_us.htm

Hi, I had something more advanced than this before (I can't seem to find it right now), but essentially you can evaluate the string in your text box, check & see how many values exist in your company with the same string & act from there: Private Sub txtCompany_AfterUpdate() Dim stCount As...

I figured this out, so I thought I'd share: Dim stVar As Long stVar = Forms!srchForm!lstSearch DoCmd.OpenForm frmName, , , DoCmd.GotoControl "lstBox" Dim i As Integer For i = 1 To Forms!frmName!lstBox.ListCount - 1 If Forms!frmName!lstBox.Column(0, i) = stVar Then...

Is there a way to get the index number of a list box row without the row being selected by passing the bound column value into VBA? Here's my example: If I have a row in a list box like this: A1 Apples B2 Oranges D3 Tangerines X4 Pineapple Assuming I want to be able to grab the index number...

[control2].Text = ""

Since you're dealing with text, you may need to split the field & reassemble it, i.e. something like: For the first one: Format(Left(strDate,2) & "/" & Mid(strdate,3,2) & "/" & Right(strDate, 2), "Short Date") The third (the first one would actually work for both one and three, unless you...

**These are just snippets, you'll need to incorporate them into full event procedures (button clicks, etc.)** so to call the first module (write and/or modify existing tags), you'd use something like this: 1. Update a tag from your database values: MP3.filename = strInputFileName 'get the...

... the module above won't create a new tag, so I had to write another one to accomplish this task. I'll eventually combine them so it's a little more transparent, but again if someone else does it and sends it to me, I'm not likely to complain ;-) 2. this is a second module, to create ID3v1...

OK, I think I have this sort of worked out now... this is a module I pulled from the web & modified for Access, so it may not be trouble-free. I've done some basic testing & it seems to work OK... 1. paste this into a new module: Option Compare Database Private mvarFilename As String Private...

I've never seen anything that could open a database remotely... however, you might consider the 'net send' command as part of a VBA procedure that would notify users at the end of a procedure that the database was available again. Call Shell("net send /users The database is now available for...

Here's a piece to play around with in the meantime, I might be able to speed up work considerably if you guys are all working on it as well. The purpose of this code is to create a new, blank ID3v1 tag into an mp3 file that has no tag at all. Eventally it will just be a piece to a larger...

I'm working on one right now... there's a thread in here somewhere that was started a week or so ago that go me addicted to the task & I've been working on it in my spare time (which amounts to roughly 10 minutes a week!). I'll post a full module once I'm finished,hopefully it won't take too...

I'm looking for a way to drag and drop file(s), i.e. from windows explorer into an Access list box. I don't need anything super fancy, just the ability to grab the path value from what is dropped into the box & have a procedure run from there. Is this even possible? I've scoured the web for...

wow, pretty much allows for complete control!! I have gotten the ID3 tag interface to work, I'm still debugging a little bit, but once I get all the kinks worked out I'm going to write a full module for the ID3 piece: Automatically populate database with ID3 information from added files...

Hi all, I'm reworking an existing database from the ground up & I've encountered an odd problem that occurs as a result of a procedure I'm building into a form. Essentially, what I'm doing is this: I have a form that displays a parent's information, and then below there are a series of tabs...