Search results for query: *

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

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

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

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 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?

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

I'm working on our intranet site with VB.NET 2005/ASP.NET When the site loads VB checks to see who is logged into the network for example: Jdough123. Based on the who is logged into the network VB changes the XML datasource to show different links on the side bar of the web page. This part...

I'm having a brain malfunction today. I'm querying the telephone numbers and names out of Active Directory. I want the query to display only the last 4 digits of column two. IE. John W. Smith - 1234. Example: Column 1 John W. Smith Column 2 555-555-1234

I have a form with 3 sub forms. Two of the subforms contain queries that update data every 30 seconds. They are not used for data entry. The middle form is where I load all of my content and data entry forms. I have a save button on my data entry form for when the entry is complete the users...

Is it possible to add users to the .MDW file from an access form? If so, how?

I am new to SQL. I'm not sure where to start if anyone knows a of a good tutorial feel free to send it over. It won't take me logn to get the jist of it. I have two SQL servers that I am working with right now. One of the databases has a table of all employees that gets added when we hire...

I have a form with 3 subforms. One is for data entry and the other two are continuous forms displaying queried data. On my data entry form when a new record is created and data is being entered, if the user clicks on one of the sub forms by accident or whatever, it saves the record. This is...

What would be the best way to update multiple tables from a single form where each form field updates a different table?

I'm trying to run reports using Crystal 11, pulling data from an Access database that's not set up on a SQL server. (MP2 if anyone knows of it). I can run the report just fine but I have to enter a secure database password each time (no user ID). All I need to enter is the secure DB password and...

SELECT [EquipmentReport].[Equipment#], [EquipmentReport].CurrentHours FROM [EquipmentReport] WHERE ((([EquipmentReport].[Equipment#])=[Forms]![Mainform]![subform].[form]![controlname])); The query works when I test outside of the form and enter in a value manually. on the save button of the...