Search results for query: *

Hey everyone. Complicated reason why we're wanting this, so I won't go there... I leave it at there are Hardware servers with some VMs on them, each therefore having the same Serial Number. Basically, I have a field (Serial Number) that contains some duplicate values. I want to delete the...

Questions: 1. When does utlpwdmg.sql run? (Other than when a DBA manually runs it) - When a user changes his own PWD? - What about when a DBA changes a users's PWD? - When a user with a profile assigned a password verify function signs in? - Other times? 2. Can you put...

Hi, all, I've done some searching but haven't found anything that helps, only people getting the same error on tables they've just created. I've just installed 10g on Oracle Linux 5, and I'm trying to get off the ground. Although I can see dba_users exists in Enterprise Manager, I can't query...

I've browsed related threads and found nothing of help. Could someone please suggest a way to import a large, fairly complex XML file to MySQL? By large I mean about 19000 lines, and by complex I mean nesting about 15-20 levels deep. I'd prefer this solution not cost me money, if possible...

Hello, I have a problem that is giving me a headache. A few days ago my firewire was working beautifully. After no known upgrades or system changes, it suddenly quit working. My camcorder screen says 'DV In' when I plug it in, but my computer will not recognize it. So here's some info and what...

Has anyone had any luck getting a Linksys WMP54G v2 with the Broadcom Chipset working on Vista 64bit? I found drivers that say they should work and I've heard testimonials of others online saying they got theirs working but I keep getting a 'code 10 - device cannot start' error. Any help?

Hello, Our company currently uses an Access DB that we're looking to transition to Oracle. We've found Access to be great in handling our problems, much more so than people give it credit for. Our problem, however, is that we have about 30 users at two different locations that are hundreds...

Is it impossible to handle single and double quotations in a string? PHV brought up a pretty tricky situation in thread705-860086 I have a similar situation and can't find a way to make it work. I've tried using a combination of the DQ variable and PHV's Replace() function to no avail...

OK, I think this problem belongs here. I was having a problem on a form but traced it down to this. Why would one query show a change in a field when an underlying table is edited without the query having to be re-run(it is open in datasheet view), but another query that's very similar not...

Hello, I have a problem I'd like some advice with. I created a form that takes a query and opens a recordset on form load like this: Public Sub Form_Load() 'rstList1 declared at the module level '------------------------------------------------------------------------------------ Dim db...

Hi, I have a form that uses sets a DAO.Recordset from a DAO.QueryDef. That recordset is then used to populate a Treeview. I want to set the recordset once, then use a recordsetclone and sort it based on different fields to repopulate the treeview. I've used rst.Sort = "[Field] Asc"but it...

Hi, I have a form that contains a treeview. The treeview has 3 levels, and I have buttons on the form that will rearrange the levels of the treeview if the user wants to. The treeview is populated with about 10,000 records on open... it doesn't take that long. However, when the user clicks a...

I have a table with 12 fields representing charges for each month. I have a report that I want to be fed the sum of the charges from last month. I don't want to update the query every month, so I'm trying this: SELECT (SELECT Sum(Format(Now()-30,'mmm') & "_CHARGE")FROM TBL_CHARGEYTD) AS...

Hello, I am using Access 2000. I have a list box, called lstCircuits on a form. I would like to find a way to set the rowsource one time, then filter/unfilter depending on command buttons underneath the listbox. I am running into problems because. a) You cannot set a listbox's rowsource...

Hello all, A page I'm working on, http://www.asmc-lol.org, has a php calendar in a div on the right side of the page. I had it displaying correctly in IE/Firefox down to an 800x600 resolution, but other people work on the page and something has changed. Now I'm having trouble getting it to...

Hello, I've been trying to read about variable scope, and have come to the conclusion that forms are objects and variables declared within them do not exist outside of them, i.e. on another form. I'm trying to have a command button open a report, and on open set it's recordset equal to the...

Hello, I would like to know if there's a way to assign a dummy value to a field that is on the report, but may or may not be in the report's recordsource. Why do I want to know this? Because, I have successfully built the code on a form to open the report, then the report checks to see if...

Hello, I have a fairly simple question, I think. I have a listbox that sets the recordsource of the form when the user clicks on a row. When the user saves certain changes, the record on the row they selected no longer meets the criteria for the listbox and when the listbox requries after the...

Hello, I know that opening a database without specifying a different workgroup to use (in the properties of a shortcut) will automatically cause the db to use the system.mdw file. I want to leave my system.mdw intact, but force the database to use a different .mdw as soon as you open the...

Hello, I have a form with a listbox, and I want to have 3 buttons under the form that change the row source of the listbox. I know how to do this, but I want the button clicked to stay down, and only go up when a different button is clicked. The buttons are labeled: 1. Open 2. In Prgress 3...