Search results

Hello all, I have a report that consists of a parent, 5 children and those children have anywhere from 2 to 7 children. This was done so that all of our different reports could be printed on one page for PDF convenience reasons. The problem. Ever since this report's conception, it has been...

Does anyone know if it is possible to parse a feed url? Any feed type will do (RSS Atom, JSON) I just need to know if I can do it in Access. Thanks for any help. Greg

Hello All, Been a while since I've posted here which is a good thing. I have searched and searched for this answer but have not found anything. So I have a Parent Report that has a bunch of child reports. These children have a bunch of children. It is a huge, slow, but unavoidable report. I...

Hello all, The normal function of a combo box as a search method is great - as long as you search by the first letter of whatever it is you are looking for. Some cases have come up where it would be nice to be able to search for June and get the result that is Xiang Xu (June). I can do this...

Detail Not Visible Based on CheckBox -Fixed...ish Hello All, I have a one to may relationship where a sample can have multiple free form reports attached to it. These are stored in a table. I have a check box on the form (and the table of course) where the user can check whether or not they...

Hello all, I have a report where I am counting based on certain criteria in the form of If such and such = this then counter = counter + 1 Elseif.... End If The counter works fine up until I hit a new page. The counter counts once, goes to the new page and then counts again. So for each page...

Hello helpful friends, I have a main form with two subforms, both of which are continuous forms bound to different queries. One subform works as it should. The symptoms of the other subform are that when I create a new record with the main form, the subform just shows the form header and not...

Hello all, I use Call Shell("C:/plink.exe databasessh -l ****** -pw *******" to open an ssh connection to a remote server when my DB is opened. Is there a way to kill that command or kill the shell or kill cmd or whatever when I exit the database? I can't see any documentation of a Shell kill...

I have a form. On this form is a field that I want to update when the user changes a field on the form (a sort of tracking feature). I can't get the on update event to run when I change a record. The only time it runs is when I click the Close button. This is no good because you can open the...

I have a ruby script that does some stuff that I need to get done. (sorry for the vagueness). To get it to work flawlessly, I need to pass it the 'SampleID' for the record that a user is currently on. This brings in 2 questions. 1) How can I call this script? (current plan of attack is calling a...

I have a form bound to a table. The table has 73,000 records and has been working mostly well for years. Lately (after a recent switch of fileservers) when someone adds a new record it will either take the first record in the table and put that info into the new record, or it will take the info...

I have a form that will quit Access at a certain time so that A backup script can run and maintenance can be performed. The form uses the timer event and displays a countdown in 10 second increments (the timer increment). I want the user to be able to finish whatever work they are working on and...

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

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

Hello All, I have a nifty automatic pdf printing scheme set up using pdf995. I use criteria from the reports themselves to name the output files for the pdf. On one of the reports they want the date to be a part of the filename. When I try to base it on a date field on a form (the form where...

Hey everybody, I have been posting a lot about my constant troubles with record corruption. I would get one line of bizzare characters and that record would be lost and I would have to go to a backup to retrieve it. I tried all of the suggestions offered to me, even the nitpickiest ones and the...

Hello all, I have a form that takes info from another form and then adds some from it's own data and then it proceeds to print a bunch of reports based on what tests were done etc. When I just print them (With preview) I have a function in the first report that prints (in its Close event) to...

Hello all, I would like to have a richtextbox for, well, rich text formatting. I have looked everywhere, searched here, microsoft knowledge base, developers network, etc. I have the RICHTX32.ocx and it is registered but I can't figure out how to get a richtextbox. How do I get the control so I...

Hello all, I have a report that prints different pages based on the testing required. This is done by having company info and general info in the page header of the report. The main worksheet area is in the page footer area and the various headings that are used for the different tests are...

Hello all, This is stricktly theory but I am wondering if any of you have had any problems with losing records while running antivirus software on a network type solution. i.e. AVG antivirus that uses one computer as the main server and all operations for antivirus software updates etc are run...