Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. load3d

    Update Command is not working when dataset is populating fields

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

    Access Subform will not open

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

    Creating a linked server to a .MDB file using JET 4.0

    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 =...
  4. load3d

    CASE Question

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

    CASE Question

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

    Crystal Report Question - Duplicate Details

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

    Update query in SQL 2005 - Item not bound

    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] =...
  8. load3d

    Update query in SQL 2005 - Item not bound

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

    Update query in SQL 2005 - Item not bound

    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 =...
  10. load3d

    Backup EXEC 9.1 and MSL5000 Library - Preprocessing hang ups

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

    Subform will not load

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

    Subform will not load

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

    Subform will not load

    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 ;)
  14. load3d

    Subform will not load

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

    Subform will not load

    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?
  16. load3d

    Cannot select a value from my drop down

    I'm not sure what the problem was exactly. I had my drop down list in a sub form and I was toying with it for awhile and just decided to take the fields of the sub form and putting them in the main form. Access isn't good at letting you know what is going on sometimes :). The fields were not...
  17. load3d

    Cannot select a value from my drop down

    I have a drop down list on a sub form thats using a query. The list is populating, but when I drop down to select an item it doesn't let me click on it. Any suggestions?
  18. load3d

    Problems with subforms and Before Update

    ACE MAN! Hey.... I'm good.. thank you for asking. Here is the code for Before Update... let me know if you need anything else. Private Sub Form_BeforeUpdate(cancel As Integer) On Error Resume Next ' \\ ERROR MESSAGES \\ Dim errmsg Dim errmsg1 Dim errmsg2 Dim errmsg3 Dim errmsg4 Dim errmsg5...
  19. load3d

    Problems with subforms and Before Update

    I have a form with 3 subforms side by side covering the real estate of the entire "Main Form". The data entry occurs in the middle form while the forms on the left and the right are queries that update data that others user are entering in at the same time. This DB has SQL back end. My...
  20. load3d

    Assign SQLDATASOURCE selected value to a textbox

    Suppose I have a SQLdatasource connection we'll call it (SQLDATASOURCE1) How do I assign the selected value to a textbox me.textbox.text = me.sqldatasource1.value

Part and Inventory Search

Back
Top