Recent content by BanditWk

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