Search results for query: *

Greetings. I am having a problem with record validation in access 2000. I have a table of records for appointments. I INSERT INTO the table records with available dates and times for the next three months when the form is opened. Those records only have the appointment date and time, and...

I am having a problem with a DoCmd.RunSQL strSQL working in some instances and not in others... When the time provided in Me.txtBlockTime is either 10:00 or 14:00 the code fails. When the time is any other time it works. I have looked at the table and confirmed that records exist with the...

Are the references I set in the Tools menu of the VBE saved in the MS Access.exe settings, or are they specific to the MDB file I set them in? I think they are saved in the mdb and thus follow that MDB whereever it is used, but I just need know for sure if I am right... Thanks! Bob L.

I need to write VBA Code to delete some files that are have security permissions set for administrators and specific users. I need to be able to write either a KILL sub or a .DeleteFile sub that will only delete those files for the current user [environ("Username")]... Any suggestions? Here...

I have a MS 2000 FE and BE that reside in the same directory. I want to set it up so when you open the FE it removes the link to the BE (regardless of where it is) and links to the BE that exists in the current directory of the FE. FE = "EquipRecord.mdb" BE = "EquipRecordData.mdb" Table to be...

Using MS 2000. I have an unbound form and I want to populate the controls on that unbound form with data from a recordset in a table in another MDB. What Refererences do I need to set in the VB Editor. Can you direct me to a "primer" about how to construct the code to display the data? I...

I can't seem to get either KeyPress or KeyDown to work on a userform in Excel 2000. Is that a known problem? Here is my code: Private Sub UserForm_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) If KeyCode = vbKeyPageUp Then GotoPreviousRecord If KeyCode =...

I have extensively used code posted on this forum by oharab (thank you sir!) to send lotus notes email from within Access. I'd like to know if there is a way to cause lotus notes to create the mail document in lotus notes and then allow the user to edit it and send it manually when finished?

I have a script I have pieced together from a couple of threads (this is my first attempt at vbs). My intent is to check and see if the local copy of an Access DB file is the same as the server copy and if not replace the outdated local copy with the new server copy (this is a front end). Then...

I have found a number of archived threads on using Double Quotes to alleviate the problem created when doing an SQL with data that contains an apostrophe ' in the data. I can't understand the syntax of using the Double quotes... Can someone give me an example of how the contents of my sql...

MS Access 2000: I have read the docmd.transfertext help file and it indicates: Ok, what is the text import / export wizard? I have created a spec in the tables view and doing a file/get external data/Import/Advanced button... but how do I get that to a schema.ini? or do I need to start...

I have some code (thanks to RoyVidar) that opens a word document read only. Can someone tell me if there is a way to open an excel file read only without having to set each individual file as read only?

Can anyone tell me how to send the command to a pcomm emmulation session?

I have a question about doing an INSERT INTO in a table with an autonumber field in the table. Do I need to fill that field somehow or will it automatically be filled when the record is created? I am getting an error on the following code: strMessageOperator = Environ("UserName")...

I have a form (Rolodex Database) with a number of checkboxes to indicate category, group, rank, and/or title for each record. There are currently 90 categories a record could belong to (each record may have more than one group, category, rank, and/or title). I currently have a subform with...

I have the following code: Private Sub cmdtest_Click() Dim dbs As Database Set dbs = OpenDatabase("Y:\Databases\devcopy.mdb") dbs.Execute "CREATE TABLE [ROTATION] (CompanyName CHAR, Rotate BINARY)" dbs.Close End Sub Which creates a new table for me. How do I tell it...

I need to set a SQL statement to retrieve all records for the last 10 days only. I have tried this: Dim RS As New ADODB.Recordset TenDaysAgo = Format(DateAdd("d", -10, Now), "Short Date") strSQL = "SELECT * FROM [Wreckers] WHERE [WreckerDate] > #" & TenDaysAgo & "#" RS.Open...

Can someone point me to an entry level learning resource about using ADODB.recordsets in Access 2000?

I'd like to change a control from a text box to a combo box when certain criteria are met. Is there a way to do this in vba? [code] If chkPref = True then ctlWrecker.ControlType = acComboBox ctlWrecker.RowSourceType = "Table/Query" ctlWrecker.RowSource = "blah blah blah" ElseIf...

Would someone please tell me how I can fill a text box with the first of multiple matches based on sql statement comparing multiple values and setting order on the field to be returned as alphabetical? something similar to txtWrecker.value = DLookup("Wrecker", "Wreckers", "[County] =...