Search results

I have a baffling problem to run by the group. One of my DB's that has been functioning quite some time has all the sudden has started having problems, namely several of the users can no longer open or add new reports to the DB. Obviously something has changed, but I can't figure out what...

Ok, this is probably very easy, but my brain has taken the day off and I've reached a brick wall. Here's the setup... We have an in-house library that employees can check items in and out of. As items are checked in or out, a database tracks the "movement" of the items. There are three...

I have a db that has multiple levels of users from supervisors, down to data entry people. On some of the common forms, I would like to lock certain fields from being editted based on the user's security. I've put tags on these fields and am running the following code when the form opens to...

At the risk of sounding like I haven't "done my homework," I'll post this question. I'm using a crosstab query to produce a sales report that breaks out monthly revenue for the year. The query works great, but there's a hitch. The way our sales dept "works," a sales month doesn't correspond...

Hope someone can help... I'm about to go insane! Here's the scoop... I've got a subform that appears on several parent forms. The subform shows the name and contact infomation of an individual related to the parent record. The parent record has a field called Contact_ID which is what the...

I've been having some problems w/ ActiveX Calendar controls recently and wondering if anyone else has had similar problems OR better yet knows a solution. In a nutshell: I have a couple of DB's originally dev'd in Access 95 using ActiveX Calendars on some of the forms. The controls are used to...

I am writing some code that updates a group of tables by deleting the old ones and then creating new ones using some MakeTable queries. My question is this: Is there some code I can use to determine if the table already exists? Basically, I want to add an If/Then statement that checks to see...

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

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

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

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

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

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