Recent content by load3d

Hello, I have a form that on Page Load event populates all text box fields on the form with sql string and a dataset. The user can then change information in the fields and update. The data is pulled using the query string as identifieridentifier. All of that is working fine...

I have an Access Database with a sidebar (subform1) and a conent form (Subform2) The sidebar of course contains only buttons that change the sourceobject of subform2 (content form) when clicked. I've narrowed my problem down to... when I click any link in the sidebar (subform1) the subform2...

Hello, I'm trying to create a linked server to an unecrypted, no security Access database. I have tried many different variations. I keep getting an "Unspecified error" SQL ERROR: 7303 when trying to connect. Has anyone ever come across this? EXEC sp_addlinkedserver @server =...

let me rephrase.... is it possible to select a value from a different query in case statement using the openquery function? I tried to do it... but I'm not sure if it's possible.

What would be the proper syntax for this? I want to use openquery to open another query if the value is null. Is it possible to do that? I'm using SQL server 2005 EXAMPLE: CASE WHEN (COLUMNNAME)ISNULL THEN Openquery(Servername 'Select TOP 1 from dbo.db.column inner join on columname) else...

Hello, I'm trying to create labels for product. If a purchase order has 6 pallets on it then I will need 6 labels. When I pass the PO parameter to the report it only comes up with one label. Of course. How do I make it so that when the report is refreshed it shows a label for each...

Okay, I got it. Thanks again River Guy you probably saved me a few failed test jobs. UPDATE dbo.tbl_InboundShipments SET dbo.tbl_inboundshipments.[Status] = 'InYard' FROM dbo.tbl_inboundshipments, dbo.qry_TrucksCheckedInFF WHERE dbo.qry_TrucksCheckedInFF.[Company] =...

Thanks for the prompt response. I'm still getting an error though "Item could not be bound dbo.qry_TrucksCheckedIn.Company"

I'm trying to create a scheduled job to update the "Status" Column in my tbl_InboundShipments to "In Yard" where the Inbound# matches the Company# in a query that shows trucks that are checked in. What am I doing wrong? UPDATE dbo.tbl_InboundShipments SET dbo.tbl_inboundshipments.Status =...

Backup Exec 9.1 and MSL5000 library running on an HP Proliant DL380 G3. Okay, I really need help. My back up jobs runs on my tape library the job starts, loads the media, then goes to a Pre-Processing stage for about 5 hours then cancels without writing any data. The status on the drive itself...

An impatient programmer? Never heard of one. >:) Still having problems with these forms. Any other possible ideas?

I have a quick question. Is linking the master/child fields necessary if the mainform and it's subform are unrelated?

Heh. Hey gents, thanks for the responses. I will try this today... I don't think I do have the parent/child links in actually. I will try it and let you know. Thanks a bunch for the responses and especially to Aceman who worked all days and all weekend brainstorming my problem ;)

I'm changing the sourceobject and the form is loading, but none of the drop downs are loading or buttons or text boxes. It's a blank form basically. The code is correct. The PK, and FK's are unique. I can open the forms just fine with docmd.openform "Form name" and they work, but it's not the...

I have a sidebar that changes the source object of the subform for each button. The form will not load when I add a record source too it. If I remove the record the form loads, every other time it just doesn't do anything. Any ideas?