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] =...
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...
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?
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...
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?
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.