Search results

Thanks for responding ! ! ! . . . Is a there a command to convert Now() to a character string ?

Can someone tell me why I'm getting the below error message. "Data type mismatch in criteria expression" I'm trying to pass a variable (via VBA) from a form to another form that retrieves a associated records to the form called. The form criteria is to match a variable that has the value of...

Mmmmmm . . . I was told in past that SQL Server could provide access to a MS Access database application on the internet. It seems that SQL Server no longer (or never was) an option. Would someone provide me with the best option for a simple MS Access database application that only ask a...

I have a MS Access database that has a form that collects data (i e. survey). I want to make this form available for use on the internet. The form creates an entry in a table, then the entry is appended to a summary table. How will MS Access work when this form is activated (on the internet) at...

Do you have a table of Survey Takers? A SurveyTakerID as a primary key ? No, Each Survey Takers will be will a new Survey Takers. Their name (first, middle, and last), address, location . . . etc. will be stored in a record for the Survey Takers. Also, the Survey Takers will only be allowed to...

cheekybuddha, Thank you for your patience ! ! ! . . . You're absolutely correct. I'm am confused, but I'm determined to find the best and easiest solution to my problem. As see, I've been searching the internet for a solution. Currently, I'm trying to retrieve one record associated with...

Oh man, I been working with the wrong piece of code. I've been foucused on the quotes and forgot about the "Where" statement. Initially, I had a "Where statement in my example (with a hard coded name). My example worked in a MS Access query. If can just get the below code to work with the...

I thought that the "Where" statement was working, it's not. What is wrong ?. Compile error. Sub or Function not defined strSQL = "INSERT INTO Individual_Spiritual_Gift_Totals (Survey_Taker_First_Name, Survey_Taker_Middle_Name, Survey_Taker_Last_Name, Survey_Taker_Telephone_Number) " & _ "...

That was it . . . . It's working now . . . . Thanks again ! ! !

I added a few other fields and now receiving errors (as shown below). Can you see the cause ? Run-time error '3346'; Number of query values and destination fields are not the same. Dim strSQL As String, strFormFirstName As String, strFormMiddleName As String, strFormLastName As String...

This worked . . . I had to change the colon to semicolon. Thanks ! ! !

This did not work.

I'm having trouble with the proper placement of the quotes for a Do.Cmd.RunSQL VBA statement. The SQL code works. Would someone add the DoCmd.RunSQL statement and quotes in the proper place for the below code ? Eventually, "Evans" will become a variable rather being hardcoded. Thanks ! ! ...

Two (2) databases . . . I'm looking into using one (1) database and hiding 'Buttons' and files. This may solve my problem.

Yes

I'm using MS Access

I tried the "Link" statement for the tables needed for the other database table. The data did appear, but when I deleted the records from the source table, it was also deleted from the other table (receiving table). When the user enters their information I want to delete it after their review...

Yes

I'm trying to retrieve data from a database table (create by a form within the database) to another database table. In other words, the users enters data, then after completion (creation of a report via table). I then want the database table data to automatically exported to another database...

Thank you for responding ! ! ! Let's me further explain, I'm trying to create a process that will allow a user to enter data into a database table (via MS Access form) and upon exiting (via button) automatically export the data into another database table. That is . . . automatic export...