Search results for query: *

Hi there all, Am needing a nice simple method to open a database to a particular record. If the database is closed it is not difficult, just use the open command argument. Getting the previously opened database to accept a call from a link is harder if its already open. Possibly something built...

If you want to send me an example of the 'serial numbers' (how they look, starting no., ending no.) and the Draw file with the spot that the numbers will go I will build the merge file for you. You can send to me on nullgod@swift-infotech.com.au if you like. I agree entirely there should be a...

Hi again, dont get me wrong, I love Draw with a passion, having used it for the last 6 years for all my publishing needs, designing cds, posters, mail outs, booklets, brochures etc...and I'm not saying to use PSP instead of Draw, but rather together. Every rastor I import into Draw is edited in...

Hi, sorry to say this but I keep on seeing people using vector tools to try to create rastor images. Its like trying to tighten a bolt with a hammer and chisel, you can do it but it may not look very nice afterwards. For buttons or Banners you are better off using corel paint or my favorite...

Sorry, I didn't explain it fully. If you make cell A1 equal to the number you want to start at, here I have just done 1. Now you just need 2 small formulas: A1 equals 1 A2 equals =A1+1 B1 equals = "/001-" & TEXT(A1,"00000") & "/" B2 equals = "/001-&quot...

Hi, This may not be exactly what you are looking for, but I have used this for numbering businesscards I use as upgrade licences. Its a little labor intensive, and I use it on v7, later editions may have something better. This is from the help file, easy steps to do it there too. "Print...

If anyone out there has connected to the AD-4324 Weighing Indicator with RS232c option I would love to hear about it. I made the RS232c cable as specified in the manual and set the units function 33 to command mode. I get a datastring automatically transmitted from the 'Ser. Out' port, but...

If you shut down the computer abnormally (ie blackout, bumped switch, etc) the file will remain on the system. With the database closed you should be able to delete the file, but while its open it is protected. Just open the access database and close it again it will normally remove the file...

This should do what you want. It loops through the entire listbox and writes the values with a comma between them into a variable. You then include this variable as shown below into your query string. If the segment.id value is a string instead of a long you will need to adjust the string...

I need to create a report for a database I have created, and its proving to be elusive. I have two tables, one with a lot of peoples personal data like name, phone, etc, referenced by a key of type long. Each of these people were recruited by someone, so they each have a reference to that...

You have 3 options for this. 1. easy...plot the x y as suggested above in the mouse down or mouse up events and use a... if x > nn1 and x < nn1 and y >nn3 and y < nn4 then 2. easier still...if the picture on a form doesnt change for that form then draw transparent labels over the top of...

Are you using Option Explicit to enforce declaration and then declaring your variables like a good little programmer? In the code above you are using PubType to compare in one instr and PubTyp in the other. PubType doesn't have a value set so will always = &quot;&quot; and give the result of...

If you are using VB5 and down try using a Do While Loop with the Instr(startpoint, myhtml, &quot;</a>&quot;) function within it to iterate through all of the &quot;</a>&quot;'s in the html script, resetting the startpoint each time to reflect where we got up to through the script. Public Sub...

If you just want to open the files in a browser the easiest and quickest is with this code here. This also includes sending an email to your default if you like and no internet controls in site! Public Declare Function ShellExecute Lib &quot;shell32.dll&quot; Alias &quot;ShellExecuteA&quot...

As a quick and easy method to perform this task try the shell object Public Declare Function ShellExecute Lib &quot;shell32.dll&quot; Alias &quot;ShellExecuteA&quot; (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As...

Hi Cooleen, I had the same problem some time back, but in Access-VBA (97). When I called a function on a form from the menubar it called it 3 times. Microsoft told me they would have a look at it for $185, so I worked around it by calling a function in a global module from the menu and calling...

Bill hates macs, so neither vb or access exist in any form for the mac(at least from ms). The closest option I have found is a VB style 'clone' called RealBasic (used to develop 'Internet Explorer 5 Macintosh Edition') at http://www.realbasic.com/, and is about $300. There are some migration...