newbie would like to know what is required to make this kind of program

I am really new to all this so please bear with me.
I am a quality manager in a small machine shop and I am trying to implement an ISO program for the shop. One of the prerequisites is that we create a history for our measuring instruments and that they are to be calibrated periodically. I was thinking that is would be great if I could create a program that would let me know when these tools need to be calibrated and have a history of their condition. Sort of on the same line as Task in Outlook. Can I do this in Access or do I need to incorporate Visual Basic or can I do this at all with these two programs?


Post your answer or comment

comments powered by Disqus
I would like to know What is the difference between 2 ways to create a RECORDSET.

Until 2007 I used to create it like this :
Dim db1 As Database
Dim rec1 As Recordset
Set db1 = CurrentDb
Set rec1 = db1.OpenRecordset(strSQL, dbOpenDynaset

But when 2007 arrived, I read Sams Elison book and then I started to create it like this:
Dim cnnX As ADODB.Connection
Set cnnX = CurrentProject.Connection
Dim myRecordSet As New ADODB.Recordset
myRecordSet.ActiveConnection = cnnX
myRecordSet.Open SQLstatement

WHAT IS THE DIFFERENCE ? is there one way that is more quick ? More efficient ?

I would like to know What is the difference between 2 ways to create a RECORDSET.

Until 2007 I used to create it like this :
Dim db1 As Database
Dim rec1 As Recordset
Set db1 = CurrentDb
Set rec1 = db1.OpenRecordset(strSQL, dbOpenDynaset

But when 2007 arrived, I read Sams Elison book and then I started to create it like this:
Dim cnnX As ADODB.Connection
Set cnnX = CurrentProject.Connection
Dim myRecordSet As New ADODB.Recordset
myRecordSet.ActiveConnection = cnnX
myRecordSet.Open SQLstatement

WHAT IS THE DIFFERENCE ? is there one way that is more quick ? More efficient ?

I've got a Macro that runs well over 100 queries as well as sub-macros. I'd like to know what query the Macro is running. My best solution so far was to create a bunch of forms that open and close with the name of each query, but that's kind of sloppy. I don't think I can use the msgbox because it prompts me to press 'OK' to continue. Any thoughts?


I would like to know what a switchboard is and how it should or can be used.

is there anyone who could explain this to me or point me in the right direction for info?

thanks in advance


Would you excuse me for my bad english ( I m French).
I m going as clear as possible in my question.
I would like to know, practically, and in a professional point of view , what is really the maximum size for an access database ?

By the same way, i would like to know how many records can we really store in one table and how many users can use at the same time a database.

I do not believe Microsoft when they say for instance than we can rely on access 2000 to create a 2 giga database, which is, i think, theorical but not practical (poor SQL queries!);

If you have life experiences about those topics, thanks to share them with me

Best regards from France

I was thrown into the database at my job because my brother left for another job and I seemed like a good choice to replace him. I don't know why, I have slim to none in terms of programming knowledge, (I am a psychology major for crying out loud), but I was willing to learn. I enjoy working on computers coding etc.
The problem. Our database is setup FE, BE. BE resides on a Fedora Core server. Eight computer connect to this at 100 Mbps. The main form "frmCheckIn" is where most of the work is done. It is huge. The Table for this form is huge, there is a lot of code behind this form, it is painfully slow to open (45sec). This problem has been going on ever since we switched to the Fedora Core (before that we only had three computers connecting to a BE on another computer. Every once in a while the speed to open will increase but not drastically. My local copy where I make changes etc it speedy as can be opening. I wondered if it was a network problem? I did some checks with the activity monitor monitoring the computer opening the form and there were spikes as the form opened up to 70% that happened at pretty consistent intervals. I would like to know what access is doing while it is opening the form. Does it retreive all records from the table and populate the form? Why the spikes in network usage. What can I do to troubleshoot some more? Any suggestions, ideas, sympathies would be appreciated. The users are getting sick of waiting forever to do their work. Thanks to all who have endured this novel. I hope I didn't leave anything out (I probably did)

Hi guys,

As I have limited experience in SQL, I would like to know what does the following query mean?

WHERE CCID = " & cc & "
AND GROUP_CODE = '" & cg & "'
AND FIRM = " & fr & ";"

I know what "cc", "cg" and "fr" represent.
What I don't understand is what the "&" symbol does.
And why in the CCID line there are double quotes only and in the GROUP_CODE row there are single quotes and then double quotes.

Thank You for your time

Hi everyone,

Now, I'm totally lost!
When I create a query with the Query Design view in Access with this SQL query:

	SELECT T_Cryzout_Disponibles.LCLCL_Disponibles_Total, T_Cryzout_Disponibles.DateEmission, T_Cryzout_Disponibles.NomReceveur,
FROM T_Cryzout_Disponibles
WHERE (((T_Cryzout_Disponibles.LCLCL_Disponibles_Total) Like 'C*') AND ((T_Cryzout_Disponibles.DateEmission) Is Null) AND
((T_Cryzout_Disponibles.NomReceveur) Is Null Or (T_Cryzout_Disponibles.NomReceveur)=''))
ORDER BY T_Cryzout_Disponibles.Ordre;

everything is good, I get what I'm suppose to get. But When I'm doing it in VBA with this code:

	RExtraction.Open "SELECT TOP " & NbrLCLCL & " LCLCL_Disponibles_Total FROM " & QuelleTable & " WHERE
(((LCLCL_Disponibles_Total) like 'C*') AND ((DateEmission) Is Null) AND ((NomReceveur) Is Null)) ORDER BY Ordre",
ConnectionBD, adOpenStatic, adLockOptimistic


It gives me an error that says:
Quote: BOF or EOF is egal to True. And I really don't know what is wrong with this. It is pretty much the same as the query I entered in the Query Design.

I'm really confuse.

Thank you in advance for your help!!!

I have seen several ways of doing this around here but would like to know what is the correct or preferred way? For simplicity lets say I have the following table structure and these are single parents with children:

ParentID (PK)

ChildID (PK)
ParentID (FK to TBLParents)

I have a main form that allows me to enter/edit information about each parent and on that form I have a subform to enter the child info. I want to be able to search for parents and children which isn't a problem for any parent or for children related to the current parent record. What is the proper way to search for a child associated with a different parent than the current record? By the way this isn't really the subject of my database, I just felt it would be easy for all of us to understand. Thanks

I am a little confused!

On my old forms my command buttons were created using the wizard, which created macros. Since I am trying to learn VBA, I want to create code for them. Therefore, I saved the macros and then converted them to VBA. There is some code on there I do not understand—for instance, “With CodeContextObject.” Below is an example of one of the codes for saving a record:

Option Compare Database
Option Explicit

' SaveAddress
Function SaveAddress()
On Error GoTo SaveAddress_Err

With CodeContextObject
On Error Resume Next
DoCmd.RunCommand acCmdSaveRecord
If (.MacroError 0) Then
MsgBox .MacroError.Description, vbOKOnly, ""
End If
End With

Exit Function

MsgBox Error$
Resume SaveAddress_Exit

End Function

Since I would like to know what is going on I decided to create a code that I can use over and over. Should I use a Procedure instead of a Function? This is the code I wrote for my save record command button:

Private Sub cmdSaveAddress_Click()


End Sub

Also, I created this first in a module called modUtility:

Public Function SaveRecord()
On Error GoTo HandleError
DoCmd.RunCommand (acCmdSaveRecord)
Exit Function

MsgBox Err.Description
Resume ExitHere
End Function

Am I doing it correctly and on the right path?



So a colleague (not in IT) created a database, it is a bit messy so I had to clean it up. It was created in Access 2003 and converted to 2007 about 4 weeks ago.

So yesterday and today I created a few new queries, very very simple because the database itself is quite simple.. I run them, it works. I go to my forms and add buttons works.

I go to hide the navigation pane via the office button and when I reopen the database it crashes when I press a button. It has happened on different buttons but after it happens once it screws the database completely.

I have tried recreating the queries and the same thing happens.

Tomorrow I will recreate the database from scratch but I would like to know what is causing this.

Has anyone got any ideas?

Hi all:

Attached is a simple Outlook Type of Switchboard that I was playing around with. This switchboard does not use ActiveX like others that I have seen out there.

If you improve on this simple switchboard could please post it back for others in in the forum. I would like to know what people think about this simple swtichboard.

The attached zip file is MSAccess 2002 version.




I would like to know what is best practice for creating user input forms for my database.

I have read somewhere ( I am sure!!) that this is best done by creating queries and basing the forms on those queries, not the tables? Is this the case? The DB is for multi-users.

Any thoughts? or advice?


You know the scenario where people keep working in an old version of a database, while you work on an update... leaving you with a new database, but old data?

This concerns a database, containing about 20-25 tables all linked together.
I was asked to make an update. In this update 3 new tables were included and here and there a few of the old tables got news fields, nothing crucial and a lot of forms were changed.

The current situation:
Database 1: contains new data, misses a few tables, is missing some fields, forms and queries
Database 1.1: contains old data, but some new extra tables, added fields, forms and queries

I would like to know if it is possible to import all data from 'database 1' into 'database 1.1', so that all linked information between the data is preserved, all database relations are maintained.

If I import tables from Database 1 into database 1.1, tables just get added, not replaced. If I delete or rename tables, I loose my relationships.

I would like to know what is a common and effective way to get all the new data of an old version of a database (where people keep working in while you work on an update), into the new version of the database, that currently contains old data.


I would like to know what is the syntax I can use to create a table field with a decimal point datatype and a field with a memo datatype? Lastly, a field with byte datatype?

Thank you in advance for your speedy response.

This is similar to "Subform AllowAdditions, AllowDeletions not obeying property settings" back in 2010.

I am using Access 2010.

I have a form with tabs and a datasheet form within one of the tabs. I want to be able to add new rows via the datasheet and so the AllowAdditions property is set to 'Yes'.

When my VBA was populating the datasheet form via a Filter property, the datasheet did not permit a new row to be added.

I have changed the VBA so that the datasheet is populated via the Record Source property and now it works.

I know I should be grateful that it is working but I would like to know what is going on.

Any ideas?

I have a form with properties set. The MinMax buttons and the Close button are left visible at this time. I have a Close command button on the form. The buttons in the top right corner are not showing. Does the command button have anything to do with this? There are over 25 fields on the form (pretty busy eh?), and I have not developed a form with this many before. I would like to know what is causing the removal of these buttons even though I have not set the properties to disable them. Any answers? Thank you sincerely.

Hello folks! I am trying to learn VBA and found a book to help me. I am using some code it gave me for an example of StrComp:

Private Sub cmdCompare_Click()
Dim iResult As Integer

iResult = StrComp(txtFirst.Value, txtSecond.Value)

Select Case iResult

Case -1
MsgBox "The first string is less than the second"

Case 0
MsgBox "Both strings are equal"

Case 1
MsgBox "The first string is greater than the second"

Case Else
MsgBox "One or both of the strings are Null"
End Select

End Sub

The debugger states that the line:

iResult = StrComp(txtFirst.Value, txtSecond.Value)

is the culprit, each time I leave one of the text boxes empty. The companion software with the same code that I downloaded for the book does the same thing.

The book is for access 2007 and I have 2010, so I do not know if something changed or if it is just bad code, but I would like to know what is generating the error.

I appreciate the help!

I try to make a database which will take data from the telephone system and work with them after. I would like to know how i will make this connection, how i will take the data in a ms access database. My telephone system is a nec SL1000

I will appreciate any help

Thank you a lot in advance

I have a form with a chart. I saved the form as a report and some strange things started happening. First off when Access wouldn't let rename the report. Everytime I did, the switch back to the original name. I tried making copies and doing Save As with similar things happening. I finally gave up and deleted the report, which it let me do, but it left a code module for the report. Each time I click on the module Access gives me error messages stating the report does not exist. What's more I am getting errors on any code I try to run, the same messages. I'm ready to dump a few hours work and go back to a previously saved version, but I'm peaved and would like to know what's up with this.

Any ideas?

Hi guys!

My name is Marina and I am new at the forum. I would like to get more information on how to import data from excel to access.
I have a sort of tool created in Excel used for people to send me technological errors. To add information to this "tool" people use userforms.
On the other hand I have an access database with all the technological issues reported. I would like to know if is possible that this information uploaded to the excel can be exported to access. I saw that it is possible with VBA codes, however, how do I do this? I have to create a table in acess and then add a macro there? or how will this work?
I am sorry if I do not make myself clear, I do not have much knowledge of this.

Thanks a lot!

I have a field that must have a response. When the field gains focus but nothing is selected from the combobox and someone tries to change to another field, a generic Access message box pops up and says that the field is required etc, etc.

I don't like the message and would like to customize it. Can I do one of the following:
a) Change the message to something better
b) Only show a message on exit that they have not entered a value in the field and that this must be done before they exit

Any ideas would be appreciated.

Good Evening,
My experience with access consists of a week worth of watching you-tube tutorials and reading access books from my local library. I realize this forum is far above my head but I have a question.

Is access the best way to do what I am trying to do (is it worth learning for this project?)

I work in the surgery department of a small hospital and wish to create a database/ application for our department. Our hospital is small and their is no budget for buying a program. I enjoy working on the computer and learning new things, so this will be a hobby/ project for me as well as benefiting the hospital.

What I would like to do:

Convert our current hand-written paper logs into an electronic computer entry system.
We sterilize instruments after surgery and must document the process according to regulations.

Ideally we will have a computer in the room that is dedicated to access and I would like to create a switchboard that in essence looks like any other application and is fool-proof for the operators to operate.

Is access the best tool for the job? Do you have suggestions for learning on my own.

Any advice would be appreciated.

I am using a batch file to automatically import a certain table which is originally in the TEXT format. The batch file invokes an ACCESS macro which does the actual TransferText procedure.

There are time that the TEXT table may not exist in the required drive and folder. But the windows scheduler is programmed to run the macro to import that table, irrespective of whether it exists or not.

I would like to know what VBA code I could write to check this. I would imagine that it would be a function returning a boolean expression to check whether the particular .txt file exists in the drive. Would appreciate help in the above matter. Thanks

Not finding an answer? Try a Google search.