Search results

You may want to try converting the Year pieces to a string using the CStr function, like this: = Display Text: IIf(Month(Now())>9,"ASFL" & Right(CStr(Year(Now()),2)),"ASFL") & (Right(CStr(Year(Now()),2)+1)))

Click Start, then My Network Places. There is an Add a Network Place choice in the left list. Click this and a wizard will start that will allow you to navigate to the server and share name on that server. It will build the path for you, you can give it a name. In the future to get to that...

It has been my experience that the trusted locations are kept with each user's profile. I have not found a way to set them once and forget it for all users. This may be different in the runtime version, I don't have any knowledge of Access 2007 runtimes.

You could also change the type of the field in the Access database to Date/Time. Then set the format properties as you wish.

While Bob's tutorial link is good, it can be improved upon. The simplest way is to develop a Network Place, then at the point in the tutorial where you type in the UNC, instead navigate to the Network Places and select the correct one. Access will convert the Network Place name to its equivalent...

1. Once you split the database, it becomes much harder to update all the front end copies with new reports, forms, etc. My advice would be to go ahead and complete as much as you can BEFORE the split. 2. You should link the front end databases using a UNC rather than a mapped drive...

Yes, I would be willing. I have written and published 4 articles, 3 in Smart Access, 1 in AccessVBA.

You can too reference a combo box in a query. I do it all the time. What you cannot do though, is reference the columns collection of a combo box in a query. I ordinarily put the column value into a hidden text box on the form, then reference the hidden text box.

I think you're going to need to develop the SQL statement, if you are not already, with code. Give the user a way to click what field to search, probably a combo box, then And Or buttons and a way to type in what to search for. A command button on the form can be used to set off the query. Its...

Is there a combination of two or more fields that could be used to join the tables? You don't have to use the PK unless you just want to. But to maintain referential integrity you must have a unique index on the "one" side of the relationship.

Couldn't you just develop a combo box for the form that contained the names of the rivers? You could also put an Add New button to allow them to add a new river if necessary.

I am pretty sure that you cannot do this as you have it now. Access will not let you fool with linked tables properties from the linking database, only from the database where the tables physically reside. However, you might try developing a Make-Table query that puts the data from the linked...

I think that the query does not know how to dig down into the columns collection of a combo box. If you want the value in column 0, that will be the value in the box. If you want a value in another column, then what I do is place a hidden text box on the form and in the AfterUpdate event of the...

I missed that you were getting the number from a table in the form's record source. Another thought I have is that you could place a command button on the form that would then go and get the number. You could place code in the After Update event of the form to ensure that there is a number in...

I have had better luck doing this by assigning a range name to the cells I want in the combo box list. Then I set the Row Source property of the combo box to the range name.

Maybe an Update query that sets the number to the next value could take care of this. You would want it to execute IMMEDIATELY after the number is assigned.