Search results for query: *

I have... Dim rsCase As New ADODB.Recordset Dim dFollowUpDate as Date strSql="SELECT Compliance_SiteCodeUS, Compliance_RecordNo, Compliance_FU6MFUDate FROM tblCompliance" rsCase.Open strSql, CurrentProject.Connection, adOpenDynamic, adLockOptimistic Do Until rsCase.EOF dFollowUpDate =...

I have a general phylosophy to keep my queries simple in the effect that there is not more than one making the end result. In the case I am working on I have a table that I need to make a crosstab to get the patient on one row instead of numerous records. Example: tableFollowUp PATID...

I have the separate mdw established and am using the shortcut I created to gain access to the mdb. Works great, but if I open the mdb directly (not using the shortcut) it opens fine. What am I doing wrong? I am missing something. Sid from Minnesota

Is there a tool that will take MS Access generated or manuall generated SQL code and format it neatly for printing? I am finding either I generate SQL code or have Access query do it for me. Once it has been executed as embedded data source in report it all crunches together and looks terrible...

I don't have access to any special tools to watch my performance out of my Linksys G router (model 1 below their new marketing faster with proprietary win plug in). I have it located in my basement of my split house with walk out basement). I can be in the room next to the router which puts me...

I can't grasp the concept of using the 'MOD' function. I look at the examples given in the help area and try with my calculator and it just does not make sense. Example 10 Mod 5 returns 0, but calculator = 0.5 10 Mod 3 returns 1, but calculator = 0.3 can someone assist with understanding...

I have four columns, they contain sizes. I want to perform calculations of Average, Standard Deviation, Min, Max and count all three together. example: size1 size2 size3 size4 ----- ----- ----- ----- 1 4 2 3 7 12 3 10...

What is being done wrong by using the wizard to copy one database within MS SQL server (live environment) to another database (different name) on the same server? It copies nearly everything fine minus the default value for bit fields, description naming and primay keys. My reason for doing...

I work with numerous databases where I have to freeze the current database in time and data for retreiving reports. Every aspect of the database needs to stay in tact whether reports are run the day of close or a year from closing. The reason is for FDA reporting. Is this a feature that has...

Anyone know of a registry hack or method to force XP Pro to execute a shut down script? I want to d/l files to my computer from the LAN when shutting down (creating current files to work offline with). Thanks Sid from Minnesota

I have a proprietary front end to my access mdb that stores numerical values as strings. To add to the issue is the value is stored as a 7 place string. If value entered was a 4 (four), the db stores it as "4 ". By using cint(trim([field])) I can pull out the '4' as an integer with no...

When I change field names in the report the system automatically updates all other fields to reflect the changed name. Example: I drag a field from my available fields list to the report area. I change the label title to something else so I can modify the actual field properties to include a...

Should be a simple answer, but I am wonding why some databases I am working on that are not mine don't have relationships built. Each time I pull in two tables into a query I have to build a relationship. What is the reason to: A. not have a relationship at the table level? B. expect the...

I have a query that displays blank (null) fields. When exporting to Excel these fields still display as blank, but when I perform column counts [countif(range,"*")] it counts even the blanks. Why does Excel import with a value of something other than blank as in Access? Is there a good...

With my personal web directory from my ISP, can I build an address book database that populates the local file on my personal directory? I assume I can with ASP and some kind of flat file. Can someone direct me to where I can learn how to do this? I thank you and my friends who use it thank...

I need to perform the following: create link to table z from data db remove data from table x append data from linked table z to table x remove link to table z One database contains all the 'data', I don't want to import the tables because they don't have descriptions and the data db is...

I run my query and have no issues. I click the export to Excel button in Access 2002. Everything transfers into a new excel workbook. I noticed one thing different was the date format... Access shows m/d/yy and Excel shows the same column with d-mmm-yy formatting, a minor issue. Easy to...

I want to calculate the age of a patient based on their date of procedure (DOP) and date of birth (DOB). I used the command: Format((DateDiff("d",[DOB],[DOP]))/365,"Fixed") This is fine for giving me a value, but the value is not a numerical value and I can not perform my statistics against...

I want to merge two tables with code. The colums are identical but the data is different in each. At no time is the data the same in both tables. I do not have another table that I can reference these two tables against. With code I want to merge the two tables and NOT make another table or...

I have two Databases that user input goes into. They were created with a front end that did nothing for descriptions on the fields within the multiple tables. I want to create a 3rd db that has a table for each table in both other db's. However my tables in the 3rd db will have the correct...