Search results

thanks DCrake, Ill message you with details. Regards, ________ CALIFORNIA DISPENSARY

can anyone help? ________ Marijuana Seed

Yes, When i drop in the value i get the following: EXPR1: Expr1: IIf([Core_1_Notes]="Yes",1,Null) Core_1_Notes Expr1 Yes #Error Yes #Error Yes #Error Yes Yes Yes Yes Yes Yes Yes Yes Yes ________ Iolite vaporizer colors

The Fields are set as text with a lookup table containing "Yes", "No", "N/A", ________ blonde girl Webcams

Hi All, I have a table that contains a questionnaire with 3 possible values for each (Yes/No/N/A). I am creating a sub-query for each column so i get a value according to the answer given, e.g; if Yes selected, then value of 3.85 given, else 0. I am using the following statement: Expr1...

Re: Send Email to a Dist List & Have Content bringing this one back as I didn't clearly state what I need; I have a macro that runs in access which then refreshes data. So for example; Table is created with current outstanding work items, a table that contains a snapshot of work items...

Send Email to a Dist List & Have Content Hi All, I would like to send an email out to a list of people with figures from specific tables, i.e. How many items receieved, cleared, outstanding. Can anyone please help? Thanks, ________ Nexium Class Action

I could put that as an autoexec in excel? But the main thing i require is to actually open the workbook frm access automatically after the macro has run. The workbook also has a password. The workbook should also save after it has refreshed. Thanks ________ Live sex

Hello All, I have a database that runs a set of de-duplication and update queries. After this is all done, I would like to Open a password protected excel file and then update the pivots automatically. Can someone please assist in module that can do this? Thank you, ________ Zoloft help

sounds interesting, can you please help me? ________ The Cliff Condominiums Cosy Beach

I might need help as to which I should reference, I'm using Office 2003. ________ Eve

I've changed it to acExport, but still getting the same problem. I Guess I could do it through Access, but it would be a little more hassle doing it that way. Any ideas? Thanks ________ Infant Avandia

All, I am trying to export excel data into an access table via a command button. This is the code I have so far in excel; Private Sub CommandButton1_Click() Dim cn As ADODB.Connection Set cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\temp\test.mdb;"...

All, I am trying to export excel data into an access table via a command button. This is the code I have so far in excel; Private Sub CommandButton1_Click() Dim cn As ADODB.Connection Set cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\temp\test.mdb;"...

Hello All, I have produced a database that looks at workflow reporting. I'm currently stuck on the following problem; Say I have a import of accounts into the database that were Un-worked at the time. After some cleaning of duplicates, the data is then appended into a main table (example row...

all, found a solution - exported as a .txt file, re-imported back into access and amended date's to correct format. ________ WEB SHOWS

All, I have a table that has dates in three fields. The problem is, when I imported them, it was done as a text format. The format is xx.xx.xxxx, I want it to be a short date; i.e. 01/01/2008. I have tried converting it through the table design view, but it says not enough memory. How can I...

Thanks Nam! ________ IOLITE PORTABLE

hi all, I'm trying to create a field whereby IF the masterkey is Like Target, then "Target", else "not target". But I can't seem to use the Like function in the field name and I get the error "You have entered a comma without a preceeding value or identifier". here is what I have; Expr1...

Hi all, I basically have three cell values (month 1 of a quarter, month 2 etc). I have created a dropdown with values; Q1 2008, Q2 2008 etc. So for example, when Q1 2008 is selected, the first cell is to change to 01/01/2008, second cell to 01/02/2008 (based on the quarterly combo value)...