Search results for query: *

I haven't found a way to do this in an Export Job. Either combining two fields, or combining a field and a string which I define. Louie, I'm going to class in a week so go easy on me ;)

Probably really simple, it's been years since my last install. Anyway, I put SQL 2000 on a new box. I can view the DBs, (Temp, Noethwind, Pubs) etc but when I open enterprise manager, I get the message "SQL Server (name) is not know to be running are you sure you wish to connect ?" I say yes...

I'm using substring([tblSearsItem].[Style],3,1) to strip out the third character as a field. The result will be 'B', 'M', 'J', or 'T' When the result is B, I want to display "Boys" in the SP as the column 'Gender' When the result is M, I want to display "Mens" in the SP as the column...

I have Combo Boxes that are based on stored procedures in an Access Data Project. Currently, I programatically change the next combo down the tier based on the current combos value, and pass the parameter to the next combo. I.E. cbo_1 After_Update() Me!cbo_2.RowSource = "EXEC sp_ColorBox'" &...

We're implementing an 1 2 of 5 system where I work. Basically, an I 2 of 5 is a unique number given to an assorment of product. For instance: I 2 of 5 number 1 could consist of 1 ea product 1 2 ea priduct 2 2 ea product 3 1 ea product 4 When adding a new I 2 of 5, I want to make sure that the...

We're implementing an 1 2 of 5 system where I work. Basically, an I 2 of 5 is a unique number given to an assorment of product. For instance: I 2 of 5 number 1 could consist of 1 ea product 1 2 ea priduct 2 2 ea product 3 1 ea product 4 When adding a new I 2 of 5, I want to make sure that the...

I have two tables. Order and Ordref. I want to set a filter on both tables, and then set the relationship using the navigational commands. I've used the SetSkip, as it is a one to many. Any ideas ?

OK, so about a week ago, I compacted and repaired a DB. This week, one of the users complains that when they change a field on the master (PK) part of a form, all of the records in the sub form "dissapear". Now, I knew what was happening immediately. The FK table wasn't updating with...

is there a way to share tabels between databases on the same server ? I have two distinct applications. Inventory and EDI. They both have thier own front ends, but are using the same back end. This doesn't make sense because theu should have their own tables and SPs except for a few common...

I have two tables, tblInventory and tblObsolete. Inventory is self explanatory, tblObsolete lists all of the items we carry and whether or not they are current. tblObsolete has 4 fields: Style Label Color Obsolete The primary key is a combo of Style,Label and Color. tblInventory also has...

Currently running XP Pro on a Dell 4300. We have a piece of software that HAS to have '98, and I'm thinking of installing it on the Dell. I'm no PC tech, and it's been a while. What am I going to need on the Floppy? I'm thinking: F-Disk ATAPI HiMem System Files Tyrone Lumley augerinn@gte.net

I'm moving and old database (non production) to a new server using this syntax: sp_attach_db @dbname = 'THICSOLD', @filename1 ='E:\mssql7\data\ThicsSQL_Data.MDF',@filename2 = 'e:\mssql7\data\ThicsSQL_Log.LDF' I get this error : Server: Msg 5172, Level 16, State 15, Line 1 The header for file...

How do I move the location of the log file (LDF) from the default directory somewhere else ? Tyrone Lumley augerinn@gte.net

OK, Friday afternoon about 2:00 all was well and good. Later that day, production reports to me that several thousand records have disapeared. There are no stored procedures that delete records, no "back ends" using ODBC and Access (except mine) and no other way to explain what...

I am sequentially reading through an EDI docuemnt. Here is a snippet of the raw data: LIN153CB919531819VASOM00064UP658378239647 ZAQA77EA LIN154CB919531822VASOM00065UP658378239654 ZAQA96EA ZAQS1EA LIN155CB919531818VASOM00066UP658378239661 ZAQA21EA...

I used to use one macro, Autoexec, that would fire when the database first was opened. I used this and a call to the API to find out who was logging in and write that to a table. After converting to ADP, I find I can no longer do this. Does anyone know a workaround, or have sample code that...

I have migrated an old Access DB to SQL Server. All of the tables are normalized and I have set PKs and FKs. I want to set relationships to enforce referential integrity and improve performance. I go to diagrams, click add new, and start setting the relationships. When I am done, SQL gives me...

I have an Access table that is populated with results from an EDI document via visual basic. The data contained is purchase order numbers and ship tos. It's purpose is to change the ship to in a FoxPro table. Normally, I would simply use the ODBC driver for fox pro and link the table. Problem...

What's the better way ? #1 Private Sub TestIt() Dim rst as new adodb.recordset strSQLStyleBody = "SELECT StyleID, [Body] from tblOrderDet WHERE JJNO = '" & Me.cboJob & Me.txtExt & Me.txtRev & "' GROUP BY StyleID, [Body]" rstStyleBody.Open strSQLStyleBody...

I have two controls, txtOrder and textQty on a sub report titled rptBreakoutBody. On the main report, I want to sum those text boxes. What is the proper syntax ? I've tried sum(rptBreakoutBody.Report!txtOrder) but it doesn't work. Tyrone Lumley augerinn@gte.net