Recent content by tbac

When I changed from Access 2003 to Access 2010, some single forms open with a previous filter so that I always have to click 'Clear all filters' before I can use the form. In Access 2003 it opens without a filter. I cant get the form to open without a filter.

In MS Access I have a 'to-do' table populated with tasks that need to be done throughout the year, and a check box for 'Done'. Right now I use a query that uses julian dates to refer to tasks that have not been done yet in the past 30 days to dates over the next 30 days. In the query I have in...

On an MS Access form, I want the user to be able to select a date from a drop down combo box that shows a range of dates from 10 days before today to 20 days in the future. Right now I have a table that has dates and I use a query that shows only dates that are 10 days before to 20 days after...

I figured it out...I had a memory variable in the button code that was set to 'Long' instead of 'Single'

The field in the table is Single. But it doesnt seem to matter. For example, to check what is going on I created another unbound control on the form and added coding to the button to update that unbound control, which is set to fixed with one decimal place. When I enter 1.3 and click on the...

I have an unbound form for the user to enter numbers, then they click on a button that updates a table based on those numbers. My problem is that there is an unbound control (text box) formatted as Fixed with 1 decimal place. When I click the button to update the table, the field on the table...

I have an issue with a replicated database where I take field data using the master database on my laptop then synchronize with the replica that is on our server at work and used by several others from the server. The problem seems to be that the references I set on my laptop do not seem to...

I opened a table in Access in design mode and found that one field had "Aen_" before the field name and another case had Gen_Field Name. Does anyone know what this means?

The replica will not let me remove the reference to VBA and the format(now(),"\RYY") function acts just like the original string I had in the text box, that is it works on the design master but not on the replica. I wasn't sure what you mean by explicitly call vba, would I put VBA.Right(... into...

The references are there on the replica and the files they reference are the same version. What I am wondering is if there is something about the replica being on a network server while the design master is on my laptop. They synchronize fine but I wonder if there is a way that I can get the...

I think you are right that I have a reference problem but it seems like it would be a common problem and there would be a way around it, and I wasn't sure if it was the reference to VBA or the reference to DAO: The Design master is on my laptop and the replica is on a shared drive on our server...

I have a replicated database with several formatted text boxes that work well on the design master but not on the replica. Example 1: On Reports where I inserted a Date text box in the footer. When you open the report on the replica, you get a message, 'Enter Parameter Value' for Date. Example...

Thanks, that did it!

Thanks, I have a text field in Access. I copied the Wingding2 circle with black dot, then pasted it into the text field in Access and it comes out as a rectangle. Is there some way you know of to make it display correctly?

I would like to use symbols similar to Consumer Reports for an access report for a ratings table. For example: an open circle, circle with a dot, circle half-black and black circle. Is there any way to make a field that would store a symbol? I would rather not do it by inserting an image