Search results

All you have to do is: 1) Link Table from db B to database A using File->Get External File->Link only very first time. 2) Delete all record from linked table. 3) Append all records from table in db A to link Table.

1) Use API function to prompt user to Windows Explorer or Common Dialog Control. 2) Store path of .pdf file to the table field from Windows Explorer file selection 3) This stored path with Hyperlink technique above will resolve the issue.

Patt is right. Use Pivot table in Access and this is what I do for Charts. Go to New Reports--> Select Chart Wizard. When you finish you can edit to the chart easy and modify anything you need like in Excel.

Why dont you create a table within database with Level Security and passwords for users and Administrator. VBA allows you control anything based on Login and password.

To create random numbers each time by weekly you have to use built-in function Rnd for numbers limit and also Randomize for make sure computer generates all the time different Sequence of numbers.

Hello everyone, If I want to read computer date in MS Access2000 and use it as transaction date stored in a table I use built-in Date() function. How to read date from Windows2000 Server computer in Network? Probably somehow to use API functions which read .DLL library? Thanks.

The solution could be like this: Create shortcut on desktop and in property Target point to "msaccess.exe". Of course path to MS Access97 and 2000 should be different. After path to executable create blank character and then indicate path to database file itself.

When you close maximized report or form use like: Forms!YourPriorFormName.Restore

If you input text box has for example name: txtMyNumber then use VBA code like this: Private Sub txtMyNumber_BeforeUpdate(Cancel As Integer) If IsNumeric(Right(txtMyNumber,1)) Then Else MsgBox "The last character must be numeric(number)!" Cancel=True End if End Sub

Re: Display a Query Total in a Message Box Use DSum buit-in function.

1) Your form should be bound to a table or query 2) Place on this form control(textbox or check box) bounded to a field. 3) In control property find Visible and set it to "No" 4) Place command button on your form and provide in VBA code window Private Sub Command1_Click()...

Why do you need subreport? Just merge all 5 quiries in on query using "Union" type query.

I had one day the same problem with linking to SQL Server database. I cannot explain the exact reason of doing this but if you relink all tables manually or programmatically everything goes nice.

I think you should try use function Format. I had similar problem when exported field Time(hours,minutes,seconds) to Excel file.

Yep, =Format(Time(),"h:nn AM/PM")

Update a new field for city using function InStr Update ZIP field using InStrRev

In another filed property "ControlSource" just type: =[YourControlName] +7

You should create additional filed for calculation PMT balance, maybe VBA procedure which accumulates PMT values. When you enter the last value for PMT and your PTM balance will >= than Orig PMT you should enclose update query and it will update another field.

In MS Access database menu find File--> Get External Data-->Import Then browse to your source file.

Yes you can do it. When use dialog box and get File Path from it you store this path to a field in a table. But what is important YOU HAVE TO FORCE pound signs in VBA code like: #YourFilePath# It works for me just fine. Take care. Igor.