Search results

Does anyone know how to set the focus to a particular tab of a tab control using VBA? I have a form w/ 3 tabbed control on it and after the user runs a search, I would like the form to open displaying the 3rd tab instead of the first. Thanks in advance! Jamie

Thanks everyone for your responses! Good luck this weekend, AK! Jamie

You could add a field to the table called something like "ChangeDate". Add this field to the form you are monitoring and set it's Visible property to NO. Then, in the Form's OnDirty event, use this code: Me!ChangeDate = Now() Jamie

I can think of two options for you. Either way, you have to make sure the calendar is unbound and use VB code to set the data in your fields. 1)You could try adding a toggle switch to the your form which would set the calendar to update the either the Loan Date or the Return date. When the...

If you are using the OnOpen event of your form, you may instead try using the OnFormat event for the Report's detail section (to get to this event, in design view, click on the Detail Section Bar of the report). The OnFormat event occurs after the OnOpen event and right before Access formats...

You should be able to put the input mask on the field in the report so the phone numbers will print with the same mask. In the report's design view, select the phone # field, open the properties and see what the Input Mask property says. If it's blank, put the mask in and you should be set. Jamie

So I can better understand your dilemma, why won't a text box suffice for your application? The reason I ask is because, unless I am mistaken, on a printed report, there really isn't a difference between a text box and a memo box. Even on a form where the user could interact with the control...

I have an Access report that I am sending to Excel using the "Office Links" button in the Print Preview screen, but I have recently noticed a small problem. For some reason, when using this method to transfer the info to Excel, only 127 characters per field(including spaces) show up in Excel...

That's a pretty major bug to have in a database program! I should think Microsoft would want to try to fix that. Thanks for your advice Axis. I'll give it a try.

Has anyone else had problems with the Page Setup values for a report changing back to the defaults from time to time? I have several databases I have designed using Access 95 & 2000 and I am constantly having problems with the Page Setup values changing. For ex., I have a report that should...

What you are talking about is fairly easy to do on a SINGLE form. What you want to do is have both flags on your form and make one of the other visible depending on the record's data. On a continuous form, I haven't been successful at doing this b/c the method I am going to show you turns on the...

I could be wrong about this, but from what I have read, you cannot do what you are asking using Access. Access is not a true client/ server database, but only acts like one in the fact that you can have your data stored in a remote location, BUT all of the transaction processing still takes...

Thanks Carol! That worked! Jamie

The report only pulls about 20 records. When I look at the information in the query that populates the report, each field has info. I thought maybe the paragraph alignment of the field might be "hiding" the data, but I tried all the alignments and none of them show the data if I sort the...

I have a report that pulls info from 4 fields. If I don't have any sorting options for the report, all 4 fields are displayed properly. The minute I try to sort the report, the field I am using as the sort order disappears. It looks as if the report actually sorts correctly, but the field is...

Sorry it too me so long to get back to you. The DateDiff function subtracts one date or time from another and returns a value measured in anything from seconds to years. The DateDiff function is formatted like: DateDiff("x", Date1, Date2) In this function, x sets what interval you would like...

You actually don't need to use VBA at all for this. There is a form event property called On Timer that performs a given event on a specified time interval. This is a great way to do what you are talking about without having to write any code. Here's what you need to do: 1) Create a two step...

I have a database that tracks the usage of a number of different physical resources in our company. I would like to try to create some sort of graphical display that shows what resources are in use at any given point during the day; basically I am looking for a timeline for each resource that...

If I understand what you are trying to do, I think the best thing for you to do is add a Date/Time field, called something like "CreateTime", and set it's default value to "Now()". This will store the the creation date/time for every new record created. Then all you have to do to find out when...

I have created a simple search form for my users to query the database. Once the user fills out the search criteria and runs the search, another form opens displaying the results. Currently, if there are no records that match their search criteria, the Search Results screen opens blank (ie. no...