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...
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...
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???
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.
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...
How can I use VBA to change the color of a cell background based off of the data. (Ex. if I type in 1.01 turn the background of the cell to "blue", if I type in 2.02 or 2.03 turn the background to "red") Any help with this would be greatly appreciated. I know I can use conditional formatting...
Everytime I open up my database I get a message that says: "Security Warning: Unsafe expressions are not blocked. Do you want to block unsafe expressions?" I then select "NO", Then it gives me another message regarding the Jet4.0 Service pack... I have gone to Microsofts page to download it...
I have 3 phone fields (Phone, Cell, OtherPhone) I need to create a query that will show the phone numbers in a cingle collumn. I want to show the phone number field first, if that is blank then move on to the Cell phone, if that is blank them move on to the otherphone, if all three are blank...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.