Search results for query: *

Depending on the type of form, in all actuality. If it's a DataEntry form, there is no need for any underlying queries, only direct access to the Table. If it's a View/Modify type of form and you're wanting to look at specific record(s), you can have the form linked to the table, but have a...

I have a database that I want to traverse through the objects and delete specific ones (there's a reason why I want to go through each and every one). For example, I have 350 Reports and I want to start at the beginning of the reports, read name, delete if needed, then go to the next report...

I would create the BegDateTime and EndDateTime fields formatted in the raw table as: Date/Time General Date This includes date AND time, provided that your Regional Settings are formatted as such. HTH Roy McCafferty aka BanditWk Las Vegas, NV roy@cccamerica.org...

Did you check your Security tab of the MDE file's Properties to make sure the flag is checked to "Allow inheritable permissions from parent to propagate to this object"? That's always been my issue when I'm working with front-end / back-end databases. HTH Roy McCafferty aka BanditWk...

Hi Chris. Well, ok, let's try this. Seeings how you had checked the DoCmd line to see if it's opening the form appropriately, my last and final suggestion would be to check your Form!OnCurrent Form!OnOpen Form!OnLoad Form!Activate (hardly used) Form!GotFocus (rarely used) and...

On the AfterUpdate of the Phone field: Dim Dbs as Database 'if not already dimensioned Dim Rst as Recordset 'if not already dimensioned Set Dbs = CurrentDb 'if not already set Set Rst = Dbs.OpenRecordset("NameOfCallTable",dbOpenDynaset) Rst.FindFirst "[SearchFieldName] =...

Check to see if the following flags are set in the Form Properties under the Data tab: Filter: <blank> Order By: <blank> <...for the previous two, I figure you're basing your form off of a Query in Record Source...> Allow Filters: Yes Allow Edits: Yes Allow Deletions: Yes...

I have this front-end database located on a network with links to back-end tables and have used Recordset coding such as: Dim Dbs as Database Dim Rst as Recordset Just recently, I've been receiving the error &quot;User Defined Type Not Defined&quot;. For my Autofill, it recognizes...

What I've done with this (because we ALL just LOVE those Managers and Executives that want to make our lives a living hell) is that I would create a Text Field for each value they're wanting to get a total for and put the following code in it: For the Pending Total Box...

View the query in Design View. On the bar, there will be a drop-down that should have &quot;All&quot; in it. You can change this to any number you want to determine how many values you want the query to show. HTH Roy McCafferty aka BanditWk Las Vegas, NV roy@cccamerica.org...

On the form, have the text box's Control Source reference to Project Cost (for this explanation, the name of this Text Box will be &quot;Project Cost Create another text box with the Control Source to Committed, but make the Visible = No. For this explanation, the name of this Text Box will be...

The &quot;Requery&quot; command works pretty nice. Also, I believe there's a &quot;Refresh&quot; command. HTH Roy McCafferty aka BanditWk Las Vegas, NV roy@cccamerica.org RLMBandit@aol.com (private) &quot;No need to send gifts, just send a smile.&quot;

I got this from Help in Access 2000: &quot; You may encounter this message if a parameter query exported to the IDC file type doesn't have data types specified in the Query Parameters dialog box. To solve the problem, do the following: In the Database window, click Queries under Objects...

Do you need the full size of the field? If not, parse out the field. If so, assign the field to a Variable and use the Variable name inside the SQL. HTH Roy McCafferty aka BanditWk Las Vegas, NV roy@cccamerica.org RLMBandit@aol.com (private) &quot;No need to send gifts, just...

Hi Jen... Well, I'm not sure where the issue may lie, but you don't have any Error Trapping in your code that will help you alleviate the guess work. Try this: 100 On Error GoTo PROC_ERR Dim EventRef As Integer Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Dim...

You need to tell the Recordset on HOW to open it. You should have: Set rst = dbs.OpenRecordset(&quot;bill1&quot;,dbOpenDynaset) if you want to make changes or, Set rst = dbs.OpenRecordset(&quot;bill1&quot;,dbOpenSnapShot) if you don't want to make any changes. HTH Roy McCafferty aka...

Hey Roy! This is Roy... I'm having the same issue with this, in fact, I tried what you suggested (I'm working on a Network) and in my Tools, it doesn't have &quot;References&quot;. I'm running Microsoft Office Professional 2000 (Access v9.0.4402 SR-1) on a (I believe) Windows 2000 server...

Where are you viewing the information? In a Table, Query, Form, or Report? If it's Table, I would probably view the information alternatively like through a Form so that you can hide the specific field. If it's a Query, don't include that column (or hide it). If it's a Form (see above) If...

You may have to create an underlying query and use the SQL code from the Query for the Row Source of the Combo Box. What you're asking CAN be done. However, at this point, it looks as if there is no link between the two tables and THAT could be a problem when you're trying to get all the...

I've had this issue since I was running Windows 95, but I just recently installed XP Pro and I'm still getting it. My Add/Remove programs have a lot of ghost images of programs I had on the system and I would like to remove them. Anyone know how I can do this? Roy McCafferty aka BanditWk...