Search results

No one would have an example of a calendar with more flexibility, would they?

How would you know whether or not it was testing true for all three statements. Using the ElseIf format, the code would quit as soon as it found the first true condition. You would need 3 separate if statements, if you wanted to test each statement.

I know Access 97 has an activex calendar control. Is there any way to display information on this calendar? I have a query that counts the number of people who have asked off for each date. Once 8 people have requested off, a date is closed. I want people to be able to look at a calendar and...

I don't think I understand your problem correctly. Why don't you just import the tables and rename them?

MHM's post in the following article provided the key to the answer: http://www.access-programmers.co.uk/ubb/Forum7/HTML/001344.html There was line of syntax missing from the sample code which took me awhile to find. I'll post the full solution here. dim oAcc2 AS Access.Application set...

Didn't work. SelectObject also defaults to working with the CurrentDB and I don't know how to properly reference the table in the other database.

Thank you. I wouldn't have guessed that the solution to working with another DB would be found under CurrentDB. The syntax for anyone who stumbles accross this in the future is: Set Db = DBEngine.Workspaces(0).OpenDatabase("DatabasePath.mdb") This solution only allowed me to get to the next...

I'm assuming your field holding the contract number is named ContractNum. Dim NewSuf as string Dim ConCount as Integer Dim ConLeft as String Dim ConRight as Integer ConCount = Len(ContractNum) 'Counts the number of characters in the contract number ConLeft = Left(Contract,4) 'Cuts off the...

I am trying to write some code that will automate the update of a number of similar databases. I need to delete a table from each database and then import a table. I believe I would have to Set DB to the path of the database I am trying to manipulate. I am using the following: Set Db =...

Not sure if this helps, but you can use the FollowHyperlink command to open applications. Simply place the following in the onclick event of your button: FollowHyperlink "C:/location/filename.exe" I use this to open a pdf that we are constantly using and it does bring it to the focus if it is...

Thanks. Worked like a charm.

I don't know how you would go about this with something you could simply put in the control source. I do know how you could write this in visual basic. Let's say your last control is named Total and your text boxes are txt1,txt2, etc. Place the following code behind whichever event you want...

I really appreciate your post jatfill. Unfortunately, I'm having a few problems with it. First, the list box doesn't quit filling out when it reaches tStop. It keeps going and then gives me an error that it can only contain so many characters. Second, it looks like it reaches its limit...

Someone had posted a link to the following article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q88657 In it, it gives an expression to represent the current month. One of my form has the current month as its criteria. When I first setup the database I manually typed this into...

Each user has their own form? And each user has a different report you need opened? Do you want the report to open automatically when they go into the form or will it be opened from a button? If I'm misunderstanding your post, this will most certainly be too simplistic. Whether its onClick...

You need to give more information. Does your subform work when you open it outside the Main Form? Do you get the same error no matter which of the 13 fields you are trying to type in? What is the relationship between the Main form and the subform? How have you defined the Master/Child...

I'm not sure what you mean by lookup wizard. If you are saying that you have a combo box that allows you to select an item and then takes you to that item's record in the form, I think it will work if you include something like the following in the after update event of the same combo box...

I've developed a solution for a few of my databases which may work for you (depending on what exactly you are trying to do). Two things are needed: a way to distinguish between new records and old ones. I have used a check box. You also need a form that will be open at all times. Create...

I have never built a pivot table before so I am not exactly clear about the extra functionality it adds. However, the actual need is to see how many people are scheduled at all intervals during the week at one time. I haven't been able to figure out how to do all the scheduling automatically...

As Rich and DBL pointed out, your method is probably not the most effective. However, as long as both forms are going to be open at the same time, you can write a code that will modify the control on the other form: If Me!Borrowed = -1 Then Forms!frmItemDetails!Available.Enabled = False Else...