Search results for query: *

We host our website through a 3rd party. I recently created a database on the site but am having a hard time creating an access page that can be viewed by everyone on the web. When I go to the site from another computer it tells me I need to change my security settings to allow it. When I do...

All the unbound fields are tied to a query using the following code. ex. on the form I have a field called "StreetName" and in the query i have the following code: [StreetName]=[forms]![frmFilter]![StreetName] OR [forms]![frmFilter]![StreetName] Is Null That code works great however when I put...

I have a form with a bunch of unbound fields on it that have a query tied to them. I am using the form as a custom filter. When I type something in one of the unbound fields it then goes through the query and gives me the answer in a report. However, I now need to ad a list box to the filter...

I have a table that consists of address street names. I would like to create a query that allows me to type in multiple street names or possibly choose from a list and have it narrow it down to a report. I don't want a parameter query, I would like to to create a form that has a large field to...

I created a query that has a date field in it. The condition is as follows: Between [Enter Begin Date] and [Enter End Date] When I try it and put in dates that I know there is data too, it comes back blank... however, if I put in dates that are before and after the dates they show up. I am...

You guys are AWESOME... Thank you very much... That worked

I typed it in and went back to my form... pressed the button and nothing happened. Do I have to tell it what field to update?

once i'm there, is that the only thing I'll type in?

Is this a macro function or VBA... If it is VBA I have no idea how to incorporate it.

Hello Again, I have a date/time field in a form and I want to have a control button that when I click on it it automatically updates the time to current time. I tried a requery macro and it didn't do a thing. I then tried a repainting macro and again it didn't do a thing. Any thoughts???

Thank you... I'll give it a try

I have an append and delete query that aren't working quit right. I am trying to append all records older than today to a backup table. I have in the query a date field that has a condition as follows: Date()-1 and when I run the query it doesn't work. Any help would be great. Thank you.

again at the risk of me sounding stupid... Help me understand what you mean by "TARGET"...

This is what I have Private Sub Worksheet_Calculate(ByVal Target As Range) Dim icolor As Integer For Each r In Range("A2:E1334") With r Select Case .Value Case 0 To 10 icolor = 6 Case 11 To 20...

I have a report that I am running and it consists of multiple records grouped by a company name. I need to have 1 company per page. I tried entering in a page break but that puts all the clients under the group on thier own page. In other words lets assume I have 3 companies with 5 clients...

I appreciate your patience. Let's assume I don't have any code to run... I'm starting from the very beginning.

I'm sorry, I don't quite follow, At the risk of sounding studpid, let's start from the beginning. I open a blank excel spreadsheet, i want to make column "M" the target. I go to type a number into column "M" and depending on that number will determine the color. What would be the VB script...

The name of the proceedure shouldn't matter, i can call it anything. I need to be able to have it as a white or clear background and then once i put in a value it changes the bacground color.

As you can see, I a little new to VBA, and don't know my way around too well. I don't know what kind of procedure I am calling... I think it is a Sub Procedure?

I appreciate your help with this... I tried this and it automatically puts in a yellow background regardless of what I type in. I need to be able to have it blank until i type in a number then have it change to a specified color.