Search:

I am trying to extract the 04 from the value 20110402A in a query. The field is called AptID. I only want the value in the 04 place holder to display for all records. I know you can use Left$ and...

Using the formula below and having an issue. I'm using the $ to "hold" the values of cells C5 and D98. This works great until I drag the formula down to the next cell. When I do the value changes...

I use the formula below to tell me if the value in any my fields is >=0 then flag it as true, otherwise it's false. I was wondering how i can modify it to say if my value in d2 = 0 or null than...

I use the formula below to tell me if I have an increase over my prior year. It works but displays a -1 or 0 for a value. Any way I can modify this to show the words true or false? Thanks..

...

By not work I should clarify. I mean it will show all the 2010 data not the next 30 days that I am looking for. I tried <=DateAdd("d",+30,Now()) . It gave me all tha data for 2010. Any other...

Using <=Now()+30 to show me the next 30 days in a query. I am using this on a date/time field, formatted to 1/16/2010. For some reason when I query on this particular table it will not work. To...

I have a query with a date field. In the query I would like to somehow show only the next months worth of data. So the query will always display next months data. Any thoughts? Thanks...

Yes it does start with an equal sign. I think there are using it as a control on a form....

Thanks John. I tried using the cide below and in the field name I got an error Name#. Did I do something wrong? Thanks..

DLookUp("[event_desc]","[event_codes_outcome]","[code_num] = " & chr(34)...

Using the code below using the DLookUp function. We are using an access 2003 db and windows xp and this worked fine. We recevied a new PC with Windows 7 and we are having trouble using the DLookUp...

Attached is a screen shot. the driver i am using is an merant 3.60 32 bit pracle 8 driver. The oracle db is 10.0....

While using on OBDC connection to link to an ORACLE table i got an error stating "ODBC call failed - [MERANT][Oracle 8 driver] optional feature not implemented. (#0). When i remove all date fields...

Fixed Wendell. Thanks. someone modified the export query and added a field that the specification did not recognize. this caused the export to fail. once i removed the extraneous field in the...

Yes eveything you mentioned is there? What else can it be?

Using the code below to export a file to a location but for some reason I keep getting an error "runtime error 3011" "The microsoft jet engine database could not find the oblect." "Make sure the...

Having trouble with excell 2007 copying a formula I've created. I made the formula =S2/A2 which gives me the total of S2 divded by the static number in a2. I want to divide s3 and s4 and so own by...

I have a date field in my query for which I only want to show the last 6 months of data from the current date. Is there some code I can use in my query to do this? Thanks..

I was able to send the email when I rem out the statment marked 10/07. It failed when I left in and me.ExemptCP = 0. Why would that make the email fail? I have records with a 0 value in the filter...

Ideally we would want to exclude that site from being sent an email.

We are using the code to send an email and for some reason it fails to send the email. The search critreia on our search form works great but when it comes to this email function it fails. I was...

That didn't seem to work. It looks like it is sending the email but it's not actually sending anything. A message box comes up and sys now outputting my attachments but when I check the sent box...

I use the code below to automatically send an email when the user presses a button on my form. They now want to preview the email and then hit send in outlook. I know .send is the command for auto...

Is there a way to "throw" a user out of an acess 2003 db? I have a PC name in my .ldb file that I can't indentify that is keeping me from updating my db because it says I have a user in my .ldb...

OS is XP.

I'm geeting an error when I try to create a user dsn data source which I was using to ldo an OBDC link to an oracle table. This works fine on my old pc but for some reason on my new pc I get the...