Search results

Adam - I didn't quite follow that. I'm placing the IIf statement in the Graduated column and will be referencing the tblEnrollment.Graduated column. What/how should I go about that? Thanks!

Neil - I don't have any idea how to set this up. Could you provide some pointers on how to go about this or an alternative solution that I might be able to use? I'm open to just about anything. Thanks.

How would I go about checking on a continuous form when a new member is being added to a table if they already exist in that table with the criteria that they are not graduated (yes/no) column? Also, in addition to the above, how would I limit the list of members from the drop-down to simply...

Why would the : With pres .Slides(index).Shapes.AddTextbox msoTextOrientationHorizontal, 10, 10, 700, 40 Line error out?

Awesome, I'll give that a whirl. I certainly wouldn't have thought of that in a million years. Thanks!

The following is some code I'm using to create a powerpoint from access data. I stripped away all non-esential code. If you look in the comments on the second portion of code you see where Access 2007 isn't processing correctly. Tells me that value is out of range and give a long 10 digit...

I have a combo box that selects a record on a form. The combo box is based off of a query and I want to be able to filter a field on the query that the combo box is being populated by. The problem is that it's a yes/no field I want to setup criteria for and I haven't been able to get an IIf or...

Really what I'm trying to do is simply design a query that will look at each unique class name and the associated records with each.

Yeah it hards to describe what I'm looking for sometimes. Right now I have a form with all of the fields listed in a stacked format. I want a check box next to each field that will be the selector for a report that will print off mailing labels. That way, anytime a person prints labels for...

I've got one of the queries figured out. Thanks for the pointer. My other issue is lying within the attached images of a query. I'm trying to take a look at all students in a particular class. If all students have Graduated, I want to enter the current date in the Class ClosedDate field...

Or just use the criteria in the Update Query?

Would I use a normal query to find the criteria and create an If Else statement and then use an Update query to change values?

I have a table that contains a lot of different information regarding to mailing. There are columns for Name, Address, Address2, Address 3, City, State, Zip, Country, Base Name, etc. Some units will only required parts of the above information. I'm using the Name as an identifier in the DB...

Alright. I've tried searching, but to be honest, I'm not even sure what to search for. I want to create some VBA that onLoad of the opening form of the database, it will take info from a query that looks for data entered for a student. It will be looking to see if there is data in two date...

Yep, sorry for not including everything. The actual module's code is: Public Function RequiredData(ByVal TheForm As Form) As Boolean 'If RequiredData(Me) Then Cancel = -1 '----------------------------------------------------------------------------------- ' 'Now to call the code, you can use...

Does this work correctly for a Native 2007 format DB opposed to an MDB? I was trying to get this working and with the few brain cells I have firing this late couldn't. I'll attempt again tomorrow, just wanted to see if you have done it with a 2007 file format? Thanks.

Yep, found it after I open my mouth, er, typed my thoughts. http://office.microsoft.com/en-us/access/HA012327191033.aspx http://office.microsoft.com/en-us/access/HA012327161033.aspx CurrentDb.Properties("AllowFullMenus") = True CurrentDb.Properties("AllowBuiltInToolBars") = True This feature...

I don't think it can be done with code honestly. To get them back you need to hold down Shift when double clicking your database and you should get all of your menus back and can go back to the prefs to reenable them. I feel as if the DB has to be restarted to gain the functionality back, but...

Just as the title describes, I need to figure out how to replace "Me" in a public function. The code is below and I need to rereference where Me.Undo is to something that will work for each instance on every form where I call this public Error Checking function. For Each ctl In TheForm...

I think you can get rid of the navigation pane and also the default menu options from the Access Options after clicking the Windows Looking Icon in the top left corner. I think customizing the ribbons however, is an awesome addition to Access. Should be very nice.