Search results

Hey, all... I'm having some difficulty with a subquery. I'm using a subquery to find a previous record's value. It works, with a few exceptions. Here's what I have: SELECT tblEventLogFile_Clean.Date, tblEventLogFile_Clean.Time, (SELECT TOP 1 previousRecord.Time FROM tblEventLogFile_Clean as...

Hey all... So, I'm firing up Crystal Reports 11 for the first time.... I need to connect to an Oracle Server, however the option does not exist in the "Standard Report Creation Wizard" under "Create New Connection," nor does it exist in the "Database Expert" under "Create New Connection."...

What is the proper way to pass an integer? I have this function and sub: Public Function testpassing(number3 As Integer) testpassing = number3 + 20 End Function Public Sub test() Dim test2 As Integer test2 = 189704 msgbox(testpassing (test2)) End Sub ...But I get an overflow...

Hi all! Is there any way to unhide an Excel sheet from an Access mdb? I can do it in Excel, unhiding a workbook's own sheets, but I have no clue where to begin if I'm attempting it from a different file. ~Andrew

I'm having a bit of problem with a spreadsheet. I'm using VBA to setup a sheet. One of the columns is annoying me. Column B is "Start Time" and Column C is "End time" Column Z (We just skipped a bit) is the number of hours between the start and end time; the total hours worked. So, cell Z4...

Hey all, I have a user who's getting strange text in her MS Word documents. When she copies an image from IE and pastes it into a new Word doc. the picture does not appear. Instead, a code of sorts appears instead: { Define the page structure. INCLUDE PICTURE...

Is there a way to move import/export specifications from one database to another?

I'm having a problem with an adapted VBA script. I just want to loop through the recordset, but Access keeps giving me grief. Dim dbs As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("(02)Unique Merchants") rs.MoveFirst Do While Not rs.EOF MsgBox...

I just linked a table to an Access Database from SQL Server. Now, whenever I open the linked table, I receive the error "Scaling of decimal value resulted in data truncation." After a quick Google search (and search of these forums), I found some solutions: So, I guess I found the problem...

Hi, all: Does anyone know of a good ASP or PHP-based reporting service/software suite that I can use to give users of a MSSQL database the ability to easily run and create reports? We need to give non-technical users the ability to easily create reports that support groupings, totals, sorting...

I wonder about the health of these forums.... My searches are taking forever to run. I'd hate for the site not to provide these forums anymore. Andrew

Hey all! Nice to be back in the database world, for now. I have a user with a problem. I helped to designed a database a long time ago. One of its functions allows the user to click a button, which runs the "sendreport" VBA function. Basically. it opens the "Compose" dialog box of Outlook...

Hey all, I'm moving from the World of Access to SQL. It's terrifying. I don't suppose you all could provide some hints... I'm designing a system with a SQL back-end, and an HTML front end. I'm putting the SQL tables together right now... <dumb question>What data type would a checkbox...

I know that I can use SQL Server as a backend in Front Page... Can anyone point me in the right direction (A link or something?) as to how I would go about doing that? I need to create a database connection, and I have no clue. I've done it with Access before (I think) but I know that it's...

I have a query that uses the round function as follows: Round([LoanAmt]*0.0125,2) This should multiply that LOANAMT field by 1.25%, and round that answer to two decimal places. 1.776 rounds to 1.78 - That's good 1.774 rounds to 1.77 - That's good BUT 1.775 rounds to 1.77 - Why? Didn't we...

I'm not sure where to begin, and I have no idea what sort of search terms I would use for this: If I have a report grouped by a text field, and the group footer counts the number of records in that group, is there any way to sort the records within that group by number of occurances? Basically...

I am attempting to use a filter when I open a form. Would anyone be able to tell me the correct syntax? DoCmd.OpenForm "FRMNewLoan", acNormal, , "Date is between 8/4/2005 and 11/15/2005" "Date is between...." is what I'm using.... I want to pull all records between those two dates. Thanks...

I realize that this issue has likely been beaten to death in past threads; my recent participation in one brought this issue to light. Can I get a general feeling from participants concerning the dangers involved in the practice of compacting and repairing databases on a server? I greatly...

We recently put together a database for a call center. The file is located on a public drive, and all users seem to be able to access the file (at the same time) and input new information. On one particular form, I've found an interesting problem: I've placed a button at the bottom of the form...

I've searched, and couldn't come up with a solution for this. Let me know if you can find a thread.. I've linked a dbase XL file into Access. When a user deletes the record in Access, it is of course deleted in the dbase XL file...Only (Just as in Access) the record is only marked for...