Search results

I can't get this code to move to the next record. There are 32 label records, but rst!label_value is stuck on record 1's value for all 32 records? (I checked it with the msgbox) Dim rst As Recordset Dim sql as string sql = "Select * from T_Labels where Code = '" & Me.cboProcedure & "'" Set...

Tim, Thanks for your help. I've used your 2nd suggestion with a twist. On entering the first bit of data, I set the combo to locked. The code behind the Post button sets the combo to unlocked. This accomplishes exactly what I wanted. Thanks, Sup

I am building a form to insert data into a table using an insert statement behind a command button. The user selects a customer from a combo box, and then enters other data into the form. The combo box value is one of the fields being inserted via the insert statement. I am trying to prevent...

Lagbolt, Thank you! I knew there was a simple solution. I appreciate your help, Sup

The problem is, my listbox isn't based on a table. It is a value list created on the fly by the user. I guess I could change the value list to a temp table, but I'm sure there is a way to delete a row from a value list. If anyone has a simple way to do it I'd really appreciate it. Thanks, Sup

I'm trying to delete a selected single row from a list box with a value list rowsource. Each row in the value list has 4 columns, and I need to remove the entire row. I tried to use Me.lstPrepaid.removeitem. Intellisense isn't recognising removeitem and I'm getting a compile error 'method or...

Thanks, their support dept is a pain to deal with, which is why I'm switching hosts. I'll try getting them to backup and FTP to me, I'm sure they won't grant me direct access. Sup

SQL Hell, These are "hosted" servers (different domains) and I don't have the permissions to backup to their server and then get in to FTP. I just tried a UNC path to my FTP on the new domain and it almost worked, at least it recognized the UNC, but I think it failed because my FTP on that...

SQL Server 2000 db backup? I need to move a SQL Server 2000 database from one hosted (via IP login) server to a different hosted (via IP login) server. It seems as though I am unable to backup to any location but the host's server. I have tried copying all objects using DTS, but it fails after...

I have a form that is used to allow users to edit existing records in an SQL server database. The recordsource for the form is a query. There is a combo box on the form which is tied to the criteria of the query, for selecting the record to be edited. I am trying to remove the ability to add new...

Glad I could help!

itazev, I believe you need to open the report in order to get a page count. This should work for you: Dim stDocName as String stDocName ="Name of your Report" DoCmd.OpenReport stDocName, acViewPreview, , , acHidden msgbox Reports(stDocName).Pages Hth, Sup

Wayne, Thank you for your reply! I appreciate your help, not just on this post, but on many issues for which I often search and find your responses! I've searched and found the following 'Backup' code: "BACKUP DATABASE mydatabasenameishere TO DISK = 'C:\SQLBackup'", , adExecuteNoRecords My...

I need to make an emergency backup of a linked SQL server database. The database is hosted and I do not have Enterprise Manager. Is there another way to do this? Thanks, Sup

I've been asked to alter an ASP form that someone else designed. I don't normally code ASP forms, and my knowledge of session variables and javascript is extremely limited so I am a little lost. There is a seperate login form which creates a session.contents("UserID"). The form I am working on...

Thanks for the advice, that's what I'll do. Have a Happy New Year! Sup

I'm looking for advice as to the best way to transfer records from an SQL Server database. I need to compare and dedupe an Sql Server database that has approximately 300K records. I have MSDE installed on my machine, but I don't have Enterprise Manager. It is requested that I don't work "live"...

Hanging Process Fixed I've read many posts without a solution to this "Hanging Excel.exe Process" problem. I solved my particular issue by moving the copying & pasting to after the transferspreadsheet then saving and quiting the workbook and then quiting the application. Thanks to all whose...

Thanks for the quick reply! Adding the following code fixed the problem. xlWB.Save xlWB.Application.Quit xlApp.Application.Quit Set xlWB = Nothing Set xlApp = Nothing Thanks, Sup

I'm having the same problem with Excel.exe process still open after I'm done with the transferspreadsheet. Did you ever find the solution? Thanks, Sup