Search results

Sorry Jeremie, Yes updating the MDAC will, most likely, update the references. You will still have to go in and remove and then reassociate them, but yes, MDAC 8.0 sp1 will contain the references that are missing provided they are Microsoft programming references and not from a specific program...

do you know which references are missing? Do you know (it sounds like you do) how to check for this information? It is possible that with your install of 2002 your references aren't installed properly, try updating your version of MDAC and then reset all of the missing references. Also check...

Pat, it is an absolute pleasure to hear from you. :) You're property is correct, but for the benefit of anyone reading this in the future, you can not set the warnings option here using DoCmd.SetWarnings. You must set the option using Application.SetOption "Confirm Record Changes", True (or...

If it is a missing reference there may be another solution. Keep reading... To compile open the db in design view and then view the code. In the code window there is a menu titled "Debug" and the first option in this menu is "Compile [DB Name]". Choose that. Forgot to mention, write down...

I'm wondering if there is a way to return the value of the warnings function (terminology??) in access. I know how to set the value, just not how to check it. I am putting together an administrative form that allows the admin or developer to switch back and forth between False and True based...

Today is one of those days where I can't seem to wrap my head around anything, so here goes. I have a database where the contact information is linked to an agency name via a third table which has the contact ID# and agency ID#, and nothing else. In a fourth table there is a list of programs...

You were trying to link your textbox to that table or the listbox to that table? Where is your search starting from on your form, and why is this in the after update event rather than being triggered by a command button?

try searching for ADO recordset and DAO reordset along with the word "addnew"

If your form is bound to a table and the field is required in the table it will automatically be required on the form

Have you tried a cross-tab query?

2 things to check on. 1: is the column you are passing from your list box the same format as the field you are trying to query off of (i.e.: are you passing text from your listbox to a text field in the query, or are you passing an integer from the listbox to a date on the query, etc.) 2...

You could just do a count query which totals the number of people and then a separate column that totals the number of verified people... or you could do a cross-tab query which would probably work better.

Me.CmdName.Visible = False is the way to hide the command buttons. Just put an event behind the On Click of the Add Client button that changes the visible value to True.

Search for "password" and "security" on this forum. There are a lot of great posts on the subject. You can be more specific in your search if you find more information than you need.

For the schregioncmd2_Click() your criteria should read: stLinkCriteria = "[region]=" & "'" & Me.schregion.Column(1) & "'" For schpayscmd1_Click() your criteria should read: stLinkCriteria = "[pays]=" & "'" & Me.schpays.Column(1) & "'" Since your combo boxes are bound to the first column...

You should use an append query. You can either set up the query in Access and reference it in VB, or if you are only using the query once or twice then just write out the sql statement in VB and go that route. If you are going to use this query on a regular or fairly regular basis it makes...

sorry, not the American system... The European system. One of these days I'll learn to read before I reply.

Format it as a short date, and make sure you are using the American system for dating. Search the forum for this, I'm pretty sure SJ put something up here yesterday about that format. Keith

What is the purpose of concatenating them into one field? Wouldn't you put the line items into a table that linked them to an order?

are you sure you used the correct file name on the server?