Search results

Hello, I have users working with a DB that I've split. I now need to make some changes to the DB on a development copy. (Need to add some fields and tables, write some VB, and more.) What is proper way to do this? If I just try to resplit the front end to point to a new backend, Access tells...

Hi, I'm a newbie, sorry if this is elementary. How do I put a link on the values in a report column to return to that record on the form? Thanks.

Hello, I have a form where I want the default value of one field to be based on a query to a table. So in Default Value for that field's properties, I enter Expression Builder and select an existing query that I have successfully run and which I know works. In Expression Builder I...

Hello, I'm new to Access and am having trouble doing what should be simple. In my form I want one field to contain a default value held in a table. I've read instructions on various sites including Microsoft's but this gets me no closer. I'm forced into using an expression builder. I just...

Hello, Sorry, I'm new to Access. Just need to know how to Autoincrement a primary key field and display it in my form in Access 2007. I have an Add New Record button which executes this: DoCmd.GoToRecord record:=acNewRec Should I add one more line in that Sub to create and display the new...

Hello, I have a report in which I've had to cut and paste some columns to get the centering of data as I want it. However, this somehow causes the column header underlining to disappear on one of the fields that I've moved and resized. I've verified that Gridline Style Bottom is set to solid...

Hello, I've looked around in vain for something that should be simple. I have a report in Access and I just want to add a where clause to it! How do you do this? When I put the report in Design view, there's no obvious place to apply or manually type in a filter. None of the searches I've...

Hello, I have a field in an Access form that I'm trying to put into the body of an email. It looks like there's a character limit of 752 characters for the body, regardless of the email client. Is there a better way of doing this: Me.eSSS.SetFocus Dim esssContent As String esssContent =...