Search results

At our site we have the FE and BE split and we just make a direct copy of the BE to 2 different hard drives, one on site one offsite. It is almost always open but not always in use. Is this bad? Could this be a source for record corruption? It copies the .mdb and the .ldb if it is open. Greg

This is acting more like an aquire program rather than a remote capture program and by that I mean it doesn't let me zoom in before I take the picture. It just opens the camera, takes a picture and closes the lens. I need to be able to compose the shot based on item size so that I can get a big...

Scratch that. I just got their example to work. It is a miracle. Um, so about that code, if you still feel like imparting a little wisdom on me that would be very great. Is there a way to preview what that camera is looking at?

I tried that one a while ago but couldn't get it to work. I am trying that WIA stuff and it doesn't seem to work. I downloaded the sample they have on their website and it stalls at registering wiaaut.dll... and I can't open the capture form. I would love it if it would work. Do you have any...

Hello all, I have searched and searched but have come across nothing that suits my needs. Here it is: I need to take pictures of all products as they arrive in our testing facility. This includes law labels and packaging. We need to be able to read said labels and packaging so we need fairly...

I limited the number of records in the list box and that solved the problem. The list box really is the best way for what I am doing. It is acting like a search field. It takes the sample ID numbers from the main table and lists them as you type. When you click on the number or hit enter it...

That seems a bit absurd that there is a limit on list boxes but your suggestion is good. I will do that. Thanks.

Hello, On a form I have a way to search for a record by using a listbox that has a Distinct Row Query from the table that the main table that the form is bound to. It looks for the Sample ID's that are associated with the samples that we test. The list ends at record 87877. We are WAY past that...

I think pdf is your best bet for maintaining formatting. Check out pdf995, cute pdf, or pdf creator. All will work very well and pdf995 has a good way of automatically naming and printing to pdf using a script provided by pdf995 (I also made it create a folder and save it there.) If you have...

Ooh I was just going to ask the same (sort of) question. Help us please.

PDF995 is just about the greatest pdf creating program I have seen. The license is $10 (free if you don't mind an add popping up before it completes the job). You can combine pdf's and even automatically print a report to pdf and name it and everything with a little script. PDF Creator is...

I don't know if this is the cleanest way to do this but I did something similar. I basically made a different query for each possible criteria. I did this based on a date (similar to yours) being either 90 days overdue or 60 etc. So in the date field in your query (or whatever your field is...

I think if you sort by Total Sales first and then Salesman second it should sort by sales first and then salesman alphabetically second. Just add Total sales to the sorting and grouping properties before salesman. I am pretty sure this works. Let me know if it doesn't so I can find something...

you can try sorting and grouping. Right click on any of he headers or detail or whatever and choose sorting and grouping. Create a new sort and choose the field you want to sort by and whether it is ascending or descending. You can give it it's own header and footer but I don't think you'll...

If your control is in the detail section then on the on format event in the properties (and subsequently VB) do the following If IsNull(Me.control) then Me.control.visible = False else Me.control.visible = True

Sorry, the creating folders thing was of my own doing, but the other code is here more specifically http://www.freeware995.com/misc/vbacode.txt

You helped me, now I can help you. PDF995 is the way to go for that. It even has some code on the website that automatically makes a folder, and names it whatever you want. It is unbelievably easy to use. It is not too expensive either. I'm not sure about free software that will do this, it...

Here is what I did and it works wonderfully (I tried a bunch of different ways to format the date and this is the one that the users liked) Call PrintPDFStatements(stDocName3, "IDFL Statement " & Format$(stdateformat, "mm-dd-yy")) It ends up being formated as 05-11-06. Thanks for your help...

Oh yeah forgot that. That is the string of the date.

pc of code? The format is Call PrintPDFStatements(stDocName1, "IDFL Statement " & dateformat) PrintPDFStatements in a module that creates a folder if one doesn't exist and makes sure the criteria is the same then it calls another portion of the module that does the actual printing. stDocName1...