Is it possible in access 97 to Create/Edit/Delete relationships with VBA? If so how can this be done.
Any help would be appreciated as I am in the middle of choosing a topic for my disser...
URGENT, NEED ANSWER ASAP.
I am using the code below in an app that is transferring a file into a named ftp site, however the new requirement is that the file must be placed into an "in-box"...
I need to find, from today's date, the date:
30 days previous,
60 days previous
and 120 days previous.
I want to generate a report that will gather all records that are < 30 day...
I am trying to use the following code:
'******************** Code Start ************************
Dim strDocName As String
Dim strWhere As String
strDocName = "rptSomeReport"
str...
I am trying to create a Make table query using two ODBC connected tables. When I use a select query a result set is returned. When I turn that same query into a make table query it returns "Re...
How can I convert a column in MS Access that is in upper case to Proper case (or title case)?
Thanks
Filips
I am importing data from an Excel Workbook by stepping through the worksheets. The problem at present is I would like to eliminate 1 prompt. When I first open the workbook, I am asked whethe...
I have an application developed with Access 2000 (on Win 2000 PC) that's using the ctschedule.ocx. Works like a dream on Win2000/98 PC's.
I'm using the Office 2000 Developer Package and Dep...
Here is the code, pretty much par:
Option Compare Database
Option Explicit
'***************** Code Start ***************
'***************** Code Start **************
'This code was or...
I want to retrieve data from my database using date comparision.
Database
Table name dating
dates date/time (short)
user text 50
Database
dates user
3/5/01 prasa...
I have a query with the following fields.
Account Number, Date, SubTotal, Adjustment, Total, Difference
The Total field is a calculation of [subtotal]+[adjustment]
I would like the Di...
My macro looks like this
SetWarnings No
OpenQuery
OutputTo
SetWarnings Yes
The Output is from an Access Query to an XL spreadsheet.
When it runs I get a 'file already exists warning'...
I am running a crosstab query and get the results I need except I need the empty fields to show 0 instead of blank. These are not null fields. I have tried the nz code but that only works fo...
I don't know how I set a password for the administrator but I need to remove it because I don't know the password. How's this done short of reinstall?
John
Hi all,
I am working on MS-Access,Visual basic.I need to update the lotus notes data to Access DB in every 10 seconds.I mean upload the data every 10 seconds.Does i need write a micro in Acce...
The following VBA code runs fine in Access 97:
DoCmd.TransferText acImportFixed, "Sams_Lbl Import Detail Spec", "Detail Table - Import", "C:\Access_Apps\Sams_Lbl\NIGHT.DAT", False, "
HOW...
When navigating thru records in my database, I null out some time values in OnCurrent, so that new time values can be entered if this record is updated.
The problem is, that this is a mul...
I am building a database that keeps track of training certificates for employees. This DB has a name, dept and a whole bunch of date fields that show when particular trainings are due for rene...
I created a Unbound report, and it works fine.
I open this report from a form, where user have a choice to preview a report, and print a report from
the option buttons.
Problem:
when use...
Is there a method to move/copy/export-import a form created in Excel into Access without having to recreate the form in Access?
I require a process to finish before the next statement in the macro is started...
Hello,
I have the following line in an Access 2000 query. For some reason, it is
not rounding correctly.
round((Project_1_Score*0.25)+(Project_2_Score*0.25)+(Project_3_Score*0.5),0)
A...
Access has a function called DatePart that can be used to generate different information from a date/time field. Unfortunately, if you use DatePart("w",[datefield]) the answer you get back (d...
Hi All! I'm trying to save text from a multiline textbox to a memo field. This text may contain "" ' , tabs or carriage returns. Are any of these characters illegal in Access? And if so, w...
I have a table that has 2 columns, PDF_File_Name and New_PDF_File_Name.
In the first column "PDF_File_Name " is a list of pdf file names, these files are located on a CD-Rom. There are over...
