Search results for query: *

Hey all I've got to figure out a way to query a memo field to only show me the numbers after CLIENTELE CALL in the memo field It would look like this in the field CLIENTELE CALL 12345 When I try a query looking for CLIENTELE CALL it returns everything in the memo field and I can't figure out...

Hi I've looked for a way to do this but I can't seem to find what I'm looking for so here's my issue I want to count all the location where colum B equals what is in colum C in the spread sheet. Below is an example and there are blank fields in between each of these entries; sometimes just...

Hey All I've got this report done in Access 2003 that shows everything required and looks quite nice. When I save it as a html page none of the lines or colors are in the html doc, just the text. Is there a work around for this? Thanks in Advance :)

Hey All I've got a simple countif and all I want to do is change the cell color on the items that fall into this criteria. For some reason I can't figure out how to make this happen ;( Here's my countif =COUNTIF(I:I,"<=29") Thanks in advance Kake

Hi I created a data page using Access 2000 quite some time ago and now that our office is converting to Office 2003 users that have been upgraded can no longer use my data page. Is there anything I can download to fix this or do I need to convert the database and datapage to 2003?

Hi, hoping someone can help me here ;) I have an excel document with two worksheets, one called Site and the other called Version. Both of these have a Location field in them. What I'm trying to do is allow the user to click the Location in the Site worksheet so it will take them to the...

All I have a query for my data page that has the following Criteria for a person name Like "*" & [Enter Name] & "*" When I run the query it works fine but when I try it in the data page I do not get any results. When I remove this from the criteria I get all the results. I have used this...

All I've tried to find an answer in the forums but I need a bit of direction to find my way ;) I get a .csv file every day with a master list of sites, this list always has new locations. I've created a table that stores this information and it imports just fine, when the table is empty. I...

Hi I'm looking to change all of my reports from Snap Shot format to Page format but I'm having one problem. At the top of my reports I like to have a total of the number and I use =Sum([CountOfProduct]) but Pages doesn't seem to like this, does anyone have a work around? Thanks in advance...

All I want to create a button on my page that will run the query again, basically refresh the page and I'm having trouble doing this. Any suggestions? Thanks

Hi All I've got a database that gets info imported into it from another one and after things where working well for about a year I now have a problem. I have a ORG table and a PRODUCTS table. I just found out that one ORG_ID in the PRODUCTS table doesn't exist in the ORG table :( Now I...

All I use the following string to search a field Like &quot;*&quot; & &quot;Example&quot; & &quot;*&quot; But I don't want to find items with &quot;Example&quot; in them that have &quot;Problem&quot;. So I tried the following Like &quot;*&quot; & &quot;Example&quot; & &quot;*&quot; Not Like...

All I'm trying to figure out a way to have the parameter be input once but use that value on two separate fields in my query. I've got two separate tables and both have fields that dates. My parameters are Start Date and End Date and I want the query to show me all the records in both tables...

I've been trying to get my macro to pause for 5 seconds then continue on but I just figure it out. Thanks in advance Kake

All I want the value of one cell to transfered in to other cells that I have choosen. Basically I want to mirror what is in the primary cell to another cell. I can't seem to figure this one out so anything would help Thanks Kake

Hi all I'm making a datbase for service and in a form I want to be able to have the star time and end time of the service call. I am thinking of having the start and end dates have a format of general date and then have the total time displayed in minutes (or hours) and I want that value to...

How do I create a macro that will take the contents of a text file and paste it in to a field in a form? It's basically a template that will be used in certain situations only.

My problem is I'm not sure how to ask what I want to do, don't know the proper terms so I'll explain it this way. In email you have a signature file that automatically shows up when you write a new email. I want to be able to do that in a memo type field in my database. Is this possible? I'm...