Search results for query: *

Hi all, I've tried searching for this problem (this site and Google), but I haven't found an answer yet. I have a query that was working fine until today. In the Field area of the QBE grid I have: Total Current: Sum([earned_current]+[unearned_current]) The query is grouped and I have the...

Hi, I have a formula which works in my spreadsheet, but I need to set it with VBA after loading the data. I've done easy formulas like: ActiveCell.Offset(0, 1).FormulaR1C1 = "=RC[1]-R[-1]C[1]" which work fine, but this one is more complicated. The formula as it works in the spreadsheet is...

Hi, I have a problem with trying to pass a parameter to a query through vba. I know, you've all heard this before. But here's the problem: I have a query that loads an array with 30 dates back from the date the user first input. I then compare that array with one from a table which I load...

Hi all, I'm trying to connect to a sqlserver database with Tomcat 5.0. I've taken over a project which someone else built and I'm having problems. In my server.xml file I have this: <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"...

Hi, I'm trying to modify a table's field properties using ADO. I've seen examples using DAO, but I need to use ADO. I've tried this: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Dim rst As ADODB.Recordset Dim fld As ADODB.Field Set rst = New ADODB.Recordset rst.Open "SouthBay"...

Hi, I'm trying to parse a field that has a delimiter and different numbers of words into seperate fields. The input file had two different delimiters, "," and "|", so I imported with the comma delimeter, but now I'm trying to split out the fields between the |'s. I found some code on a site to...

Hi all, I have a multiuser (about 25 users) database which is split into a front end/back end setup. Everything was working fine when I had the front end on the local hard drive of my users' PC, and the back end data tables on the server. Then I moved the front-end mdb to the server also. As...

I am running Windows 2000, and I must have messed something up, because now when I double-click on My Computer, it doesn't show C:, but when I go into Windows Explorer, I *do* see C:. Can anyone help please? &quot;One Database to rule them all, One Database to find them, One Database to bring...

Hi all, I'm trying to build a macro in Word 2k that will replace certain text. I did a record macro and it built the macro and replaced the text, but when I run the macro, it doesn't do anything. The text I want to replace is in a Text Box... do you think that's the problem? Any help would...

Ok, I admit it: I'm color-blind. Not completly; I can see most colors, it's just the red-green-brown ones I get confused. Now the problem: My pointy-haired boss wants the background color to match the company color. The help just says &quot;The BackColor property contains a numeric...

I'm building a new Athlon XP 3000+ with an Asus A7N8X Deluxe mobo and 512mb ram. I have a new case and I'm transferring all the other components from my old PC (Athlon 600Mhz). I have a 300 watt PS that was working fine in my old PC. Now the problem: When I put it all together and hit the...

I get the above message when a user is at a certain point in the database. The database worked fine until I split the tables from the rest of the data base. The database has 20 form with about 150 fields (it is a questionnaire) with a yes/no look up table. In the 12 form at the 111...

Is there a limit to the number of Select Case statements you can nest? Right now I have this (below)and I'm getting a &quot;Compile error Case without Select Case&quot; Select Case Status Case 1 Print Case 2 Select Case DayOfWeek Case Monday Docmd.CancelEvent...

Hi, I'm trying to create a database which has multiple tables with multiple forms relating to just one record. I can't seem to get the next form/table to update when I enter the information. I have each form linked to each table. And when the user has finished answering the questions on the...