Recent content by OwenHall

I was trying to connect my desktop PC to my laptop using Wifi and changed the network from a domain to a workgroup. I restarted the PC and now it will not let me get passed the login stage because it can not verify my password on the network that I created because it does not exist. All I want...

I am in need of some help with regards to joining two seperate XML documents together with a common identifier. I am usng xPath and DOM to open files up. The relationship is based upon Customer Codes that are present in both files. xml file 1 contains custid custname 123456 Ron Weasley xml...

I need to print a form to a printer whenever a new record button is pressed. It has to be a specific printer. Does anyone know what code to use and controls?

Thanks

Someone spilt coffee onto my laptop keyboard and now it is not working (The top row 1-9 kind of works). I tried to put a keyboard into the PS2 port but this is not working either. Can I use the keyboard through the serial port (using a PS2 adapter), and if so what settings do I need to use to...

I have, as I said it used to work on my win98 pc. I was thinking it might be something that I have to add, like dbase extensnions in Data Sources (ODBC)

I have tried to create a report which has a date formated to the a long date using "=Format$([Date],"Long Date")". But every time when the report is opened it asks for the $format parameter. I have used $format before on my Win98 pc, but since moving over to Win2k, I have had this problem. Can...

I've tried different variations on the format front but to no avail. What should I check in my references?

Thats what I am doing at the moment, but I was curious as to how "format$" worked on Windows 98 and not Windows 2000. I thought someone may have an answer as to how to get it working under the Windows 2000 operating system.

I have tried to create a report which has a date formated to the a long date using "=Format$([Date],"Long Date")". But every time when the report is opened it asks for the $format parameter. I have used $format before on my Win98 pc, but since moving over to Win2k, I have had this problem. Can...

Still need help on this one. When I say the SQL is Blank I mean that when it is run the result brings back nothing under the field names.

I tried it out but could not get it to work. I kept getting errors when trying to open or load the form.

Thanks Tiny, I shall tru this out and see what happens.

On my Access 97 form 'frmGroup' I am populating text boxes using a subform 'frmSelections', who source is a query 'qryProductCostTypeA'. When qryProductCostTypeA is empty, frmSelections comes up blank and so the textboxes on frmGroup are populated with the '#Error' message. An IIF statement...

Expr1: Format(Sum([TimeAllocation])," hh:nn:ss") I forgot to mention that the time allocation was to be formatted to hh:nn:ss. This works, but the SUM does not. Any more tips?