Search results

Let's say I have a form with multiple tabs. If the various tabs are clicked, the form always looks the same. Would it be possible to have it so that only the left most tab (say tab A) contains data and other tabs (B, C, etc.) are empty? But by clicking a button, the user can duplicate the data...

Hello all, I put some very simple code in a form. When a user tries to save a record or move to a different record, a dialog pops up that asks them if they are sure they want to save changes. It works just fine in the form. However, I have a user that likes to switch to datasheet view and do...

Using Access 2007. When I run my report, it prompts for a beginning and ending date as it should. However, it also prompts for 3 fields that are no longer included in the report or the query (they were at one time). The query runs fine and prompts for beginning and ending date only. I looked...

Access 2003 Is there a way to find out which users are members of a security group in the workgroup file?

If Month(Date) > 6 Then FiscalYear.Value = Year(Date) Else FiscalYear.Value = Year(Date) + 1 End If Since Month(Date) = 7, I was hoping this would return 2011, but it returns 2010. The + 1 must not work?? Thanks for any help.

Would it be possible to populate a Fiscal Year field by somehow looking at the system date? Our fiscal year runs from July 1 to June 30. What I want to happen is if the month is January through June, I want the field to display the current year. If the month is July through December, I want...

I am using the following expression to retrieve the latest year in a column of dates: Max(Right([EnteredDate],4)) This worked fine till we rolled over to the new year. The last two dates in the column are 12/23/2009 and 1/05/2010. I want the expression to return 2010 but I guess it still...

Not sure if this belongs in tables or queries forum, but I'll start here. On an Inventory Item form (based on a query), one of the fields is Equipment Category. Normally I would do a lookup on the Equipment Category Description (from the Equipment Category table), and then store the Equipment...

Access 2007 I am trying to change the field size of a column (or delete the column all together) and Access won't let me because it says the column is involved in a relationship with another table -- I must first remove the relationship. I have removed every relationship in the entire database...

Access 2007. I get a Type mismatch in expression error when I try to open a form. It is a split form based on a very simple table, not a query. The form worked fine all week but obviously I've done something recently to trigger this problem. Any help would be greatly appreciated. Thank you.

I am a novice programmer at best so hope this question is an easy one. I have a form that has a button on it called View PDF. When clicked, it grabs the data from one of the fields on the form (PermitNumber) and then opens up the related PDF document. The code for this is below. What I need...

If you're not familiar with the work of Steven Wright, he's the famously erudite scientist and comic who once said: "I woke up one morning and all of my stuff had been stolen and replaced by exact duplicates." His mind sees things differently than most of us, to our amazement and amusement...

I've always been fascinated with weather. Anyone have any cool weather pics? I'll post a few. Two of the pics are supposed to be of Katrina. The other is a twister I got very close to last summer in Wisconsin.

Would it be possible to open a .pdf file based on what is found in two different fields on my form? For example, I have a form that searches for Land Acquisition records. When a record is returned, two of the fields are County and Route. I would like to have a button that opens the...

I have a simple database that opens with a main window displaying 5 buttons that can open 5 different forms. I have created 2 security groups -- one that allows full access and the other read only. When logged in as a Read Only user, there is one form that spits out a runtime 3011 error, could...

For the sample table below, Station Offset Slope A 3 21 A 5 19 A 7 14 B 1 8 B 1.5 6 B 3 5 B 7 2 Would it be possible to use a query (or any other way) to create a new table out that looks like this? A 3 21 5 19 7 14 B 1 8 1.5 6 3 5 7 2 In other words it alternates...

I have a form that contains a field populated by a combo box. When I scroll back and look at previous records, the data in this field sometimes displays, sometimes does not. Looking at the source table, there is data in this field for every record, so the data is getting saved. However it...

After the form is already open, our users want to sort on a text field that is a combination of numbers and text. They want the sort in descending order with 7L-1500A above 7L-856, etc. I have created a query with a rather complex expression that will accomplish the sort correctly. I have a...

Does anyone know of a good reference that lists and describes all of the available functions (len, right, left, val, etc.). I'm not fond of wandering through Access 2002 Help.

I used the wizard to insert a button used to create a duplicate record. The button worked fine under NT but since we've converted to XP, it causes an error. All I get is a message that says 'The record that Access was unable to paste has been inserted into a table called Paste Errors'. I...