KiwiGenie
Last Activity: Jun 11 '11, 11:09 AM
Joined: Mar 6 '07
Location: NZ
-
Very helpful thanks, now just need to find a friend with a cd. -
That was quick..thanks!
Off to find out about backups...Leave a comment:
-
Thanks for that, I did find some methods by googling in the end, but they required you to have an i386 folder directly in the c drive, which my son's computer doesn't have.
Do you know if I can use any xp home install disk with my license key for xp home?
Thanks :)Leave a comment:
-
I finally found it, it's a part of the ThinkVantage Rescue and Recovery program which came with my computer. My son's computer doesn't have the same program though, so does anyone know how we can make a windows xp disk for him? His computer has become a bit clogged up and it's time for a clean start..
Thanks :)Leave a comment:
-
How do I make an xp reinstall disk?
When I got my computer it came with windows xp preinstalled, but no disks for it. Months later I found out that windows would let me create a set of reinstall disks, but only once.
Now my son has a computer with the same deal - no disks, and I can't remember where to go within windows to create the disks. Can anyone help?
Thanks :) -
Yes I did have the yes/no field on the report as well, so changing it to a checkbox and changing the code did get it all working. If only experience with code-writing was something that could be gotten quicker!
Thank you both so much for your help :)Leave a comment:
-
How to make image on report visible using yes/no field as criteria
I have an image on my report that I want to make visible only when a yes/no field is true. The yes/no field is a hidden text box called txtTried. The code I've been trying to use is:
I got this to work on a form by using the same code in the Form_Current event, but it won't work in my report. Have tried it...Code:If Me!txtTried = True Then Me.imgBerry.Visible = True Else: Me.imgBerry.Visible = False End If -
Problems exporting report to HTML
I have some reports which contain subreports that I want to export as HTML documents.
The code all runs smoothly, but when I open the HTML files I can only see the information that was contained in the subreport, the spaces where the fields on the main report were are just blacked out boxes.
I've checked all the backcolor settings, but they're all set to white, the same as for the subreport, so it isn't that.
I've also tried... -
Thanks for your reply.
I guess I will be installing everything the computer originally came with. Its just kind of annoying because a) There wasn't really anything I ever use amongst the preloaded software, some of it was trial software which is one of my pet hates, and I feel that if I have to uninstall stuff then I no longer have a fresh clean xp install. Also b) just the windows updates alone to get the service packs back again takes such...Leave a comment:
-
Can I reinstall xp without bundled software?
The time has come where I want to format my hard drive and reinstall xp so I can start off nice and fresh and uncluttered again.
My machine didn't come with any discs for reinstalling and it was months before I found out I was supposed to make some, so I'm not sure if they will be just the operating system and bundled software or what, also I didn't have any dvd's on hand at the time so I ended up with the boot cd plus I think 5 or... -
Thank you! I was thinking RowID was a property or something..lol
Its all working good now, I had to use qryReportX as the report recordsource, so after the loop I set the sql back to what I want it to be if opening the report instead of outputting it to HTML (if that makes sense). So now I don't need the where clause on openreport either! :)
...Code:Private Sub CommandHTML_Click() Dim qd As DAO.QueryDef 'Set "Microsoft DAO version
Leave a comment:
-
I'm not so sure I've gotten over the fear thing! lol
Now that I made a query qryReportX I get the error on this line instead:
I'm not sure what tblX should be. I changed it to tblRecipes, the table the recordset is based on, but I'm not sure if this is right.Code:qd.SQL = "select * from tblX where RowID=" & rs!RowID
I want to start with only the selected records then output HTML for each (Selected is a yes/no...Leave a comment:
-
OK I'm sure I'm getting somewhere with this, however I am fully self-taught with Access, and I have never used OpenRecordset or QueryDefs before, in fact I have actively avoided them! Hopefully though they are not as scary as they first seemed.
At present, when I open the report (whose recordsource is tblRecipes) I use the where clause:
So this...Code:DoCmd.OpenReport "rptRecipes", acNormal, , "[Selected] = -1"
Leave a comment:
-
Output HTML report for each selected record
I have a form which lists selected records, there could be anything from 1 record to all records selected. I want to output a report for each record as HTML. I want each file to take its name from a certain field (RecipeName), so can't simply put a page break in the report.
Would it be possible to create a loop which opens the report hidden, then exports it to HTML, then closes the report, and does this for each selected record? Or would all... -
Ok, something is wrong already, when I select the first recipe, nothing happens in the subform, then when I select another recipe, the first one shows up, select a third and the second shows up...
Any ideas?Leave a comment:
-
Hi..First off, no worries about any delays, I get busy too! Besides I've had time to play round and learn a bit more about what I'm trying to do.
I came to that conclusion last night after trying it with the listbox on multi-select, and using the ItemsSelected property. I got this to work, but when I changed categories in the combobox then clicked on a recipename the previous selections would disappear from the subform. What I have...Leave a comment:
-
Just to update I have added the subform now and added the following code to the listbox:
This works if I click on one recipe...Code:Private Sub RecipeName_Click() Dim strSelected strSelected = strSelected & "SELECT * FROM tblRecipes WHERE tblRecipes.RecipeName ='" & Me!RecipeName & "'" Me.SubfrmSelected.Form.RecordSource = strSelected End Sub
Leave a comment:
-
Hi..thanks for the reply. I am still very much an access newbie and I'm not sure I understand how the checkboxes would work, but it really got me thinking and I wondered would something like this work:
Unbound main form
--Combo box - FoodCategory
--Listbox - Recipe names matching chosen category, hopefully would be able to include an "all" option to select a whole category.
Then when a recipe name is...Leave a comment:
-
List records sorted into category groups with subheadings
I have a form which lists all records for the user to choose which ones to print. Its a continuous form with a checkbox for each record, bound to a "selected" yes/no field in the table.This works well for what it is, however I really want to split my list into categories. I can do this in reports but don't know how in forms and searching has been unsuccessful.
In my table I have fields for FoodCategory, RecipeName, Selected, and... -
IT WORKS!!!! :) Thank you all so much for the help. I tried shutting down the firewall, that didn't work, though I thought that might be it, it was the cable in the end, I plugged in the crossed over cable and it just worked. My son will be very happy when he gets home from school...we made him do a lot of dishes to get the adapter in the first place, parental guilt has been running kinda high..lol
Thanks again
JennyLeave a comment:
No activity results to display
Leave a comment: