Search results

Thanks again. Your second comment brings me back to my starting point. How do I establish this link between development front end and development back end when I'm using copies of an already-split DB? I don't see such an option in Access. I see Split, but I don't see anything like "re-point."

Thanks, Bob. But suppose I need to spend several days in development, during which my users need to keep working. Wouldn't I need a parallel, independent copy of both the front and back ends? If so, how do I copy the pair and retain a link between front and back? My plan is to take my time...

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...

Thanks. Can you tell me where I run DMax and what triggers it? My scenario is this: The user wants to begin data entry with incrementing ID numbers starting at 500 . At some point in the future he wants to import historical data that has IDs from 1 to 400.

Thanks. You might very well be right. It is in fact static data, with the exception that the owner of the DB will want to change it more or less permanently, occasionally (if that makes sense). So I thought it made sense to store the data (a few paragraphs of text) in a table and let him...

My query, btw, is just a simple select statement from a table with a where clause, such that I get a single value as a result.

Thanks for your reply. I've learned a couple things since I posted. I now understand that you have to create a query and save it, then reference that query in the Default Value field. But this now is where I'm stuck. On my form I have a field, of data type Memo. I have created a query and...

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...

Thanks, Bob. I did search this forum as you suggested and saw one post saying that an Autonumber can even be negative! Is this true? We're happy here to assign our record IDs to whatever integer Access comes up with, but not if it's negative. We're also keen to avoid numbers below 500 since...

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...

Thanks very much for that reply. If my customer uses Thunderbird as their email client, could any of this still apply?

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 =...