Search results

I have the following code running from a simple click event: Private Sub btnWeeklyReport_Click() On Error GoTo Do_Nothing DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "WeeklyReport", txtExportFile MsgBox "The tables have been successfully exported to " &...

Hi, Have two tables: tblAccounts pkAccountsID fkNUmberID tblNumber pkNUmberID NumberDetail I have a form which had the tblaccounts created using the wizard. I then remove the fknumber field and replace it with a drop down combo box. My question is! How do I lock the value selected in...

Is it possible to have a pop reminder system and task management area within Access, something similar to outlook but completely autonomous. For example I have lodged a job and I want my system to remind me to check on it on a given date?

Thanks for that Nidge, I will try to incorporate the encryptkey function into that.

Hi Nidge, Thanks for your reply. The sort of thing I am looking for is this: Field box named: Box1 Command button Field box named: Box2 The user enters the plain text password in Box1, hits the command button and Box2 displays the encrypted password. And vice versa. Whether a...

Hi there, I understand that you can use the following in the immediate window to password generate ?EncryptKey("Password")635 586 600 600 604 580 601 591 ?DecryptKey("635 586 600 600 604 580 601 591 ")Password But I want to do this in a form with a on click event using maybe an unbound...

I have been searching the internet for an example of how to make a form that I can use to select query criteria from. For example: Form Select accounts with "Gas" or "Elec" or "Water" In a drop down box then maybe have two fields with date from and to perios for the active dates. Any...

How would I make this following code an IF OR statement? Code: =IIf([Sum1]+[Sum2]+[sum3]=3,"Sorry this is not a valid claim","Valid Claim") So the Or would be [Sum1]+[Sum2]+[sum3]+[sum4]

Hi, I use the following code on my search box. But I want it to goto the searched record in the form not filter it, how do I achieve this? Private Sub cmdSearch_Click() If Len(cboSearchField) = 0 Or IsNull(cboSearchField) = True Then MsgBox "You must select a field to search."...

Hi, Is there anyone that is able to tell me whats wrong with the following: =IIf([OriginalAmount]-[RebillAmount]=0,0,(Nz([OriginalAmount]-[RebillAmount]=0,0,Nz([OriginalAmount],0)/(DateDiff("d",[dteOriginalFrom],[dteOriginalTo]))*365)+Nz([CashReturn]))

:confused: Hi there, I have a table that stores account numbers and other data. The account numbers are the primary using a number field with long integer. The problem I have is some of the account numbers are too long for the long integer max field size. Can I use a text field instead...

Hi all, I am trying to get hold of the Access 2003 Developer Extensions. I cant seem to find them anywhere. Can anyone help?

A check box can be stored in a table as the following: Yes or No 1 or 0 True or false Essentially its a switch and my guess is that your tables are not normalised correctly or you are searching for the wrong value in your query.

Hi there, Not quite sure why you quote a web database. A database is a database and not necessarily for the web or an application. It is defined as a mean of storing and extracting information efficiently without too much effort. Web technology utilises databases through code such as server...

Hi there, Not quite sure what you are trying to achive really. In logic you have a 1 or 0 which transpires to true or false. It would not be logical to create a seperate field to count as a blank. You have three types of data: 0 - false (populated) 1 - True (populated) Null - unpopulated...

Hiya you gave me the key work UNBOUND. I have made the changes and its fine. Thanks Gina

Hiya, yes its UNBOUND

Hi there, I have managed to implement the common dialog API on my form which allows me to select a file name and store it in a field. The problem I am having is I have a continuous form and when I populate the field with the file name it changes all the other fields to the same. Is there...

Hi All, Does anyone have any experience using the common API in access. Im trying to achieve the following: Unbound Field showing the location of a file two command buttons = Add a File location / View the file in the unabound field Any help will be great Thanks Chris

See my reply in your other post too :)