Search results

Another goofy question... I have a database being used by about ten people and some of them use different forms. Rather than have ten databases opening different forms when opened can I make a batch file tell which form to open when run? From what I've seen on google it looks possible but I...

That did it. Thanks for the help. Much appreciated

So I'm getting an error telling me Run time error '3075' Syntax error (missing operator) in query expression '8/24/2015 2:10:39 PM' When I have this as an on click event for a button. DoCmd.RunSQL "UPDATE [tblexelpick] SET [close time] = " & Now() & " WHERE [tblexelpick].[ID]...

I've got this code for the open of the form... Private Sub Form_Open(Cancel As Integer) Dim rsNewsItems As Dao.Recordset 'Reference to DAO must be selected from Tools->References Dim strNews As String Set rsNewsItems = CurrentDb.OpenRecordset("marquee", dbOpenSnapshot, dbReadOnly)...

I had looked at that post once before, although re-reading it I did find some improvements I could make. But I still can't find a way to get it to "change on the fly" as it were. I did find how to make it go through every record in the table and display them one after another so that's very...

Hi guys, I've been playing around with trying to make a scrolling marquee on an access form and it works. Kinda neat, or not. Anyway I can't figure out how I could get it to change. Here's what I've got.... Private Sub Form_Open(Cancel As Integer) message = "my message" End Sub...

Thanks Jdraw. I'm seeing some examples there that are making things seem clearer.

There is no application or business side. It's a hypothetical. A learning exercise if you will on how to create a do/until loop.

Here is another hypothetical question. If I have a form with ten text boxes. text boxes 2 through ten have a default value of the previous value plus 1. So.... TEXTBOX1 TEXTBOX2 default value =[textbox1] +1 TEXTBOX3 default value =[textbox2] +1 TEXTBOX4 default value...

Solved it Here is what I did Dim db As Database Dim rec As Recordset Set db = CurrentDb Set rec = db.OpenRecordset("select * from [Daily Run] Where field2 = '" & Me.list12.column(0, field2) & "'") If (rec.EOF) Then rec.AddNew rec("field1") = Me.text11 rec("field2") = Me.list12.column(0...

Nope. That didn't seem to work. Here is the entirety of the code Dim db As Database Dim rec As Recordset Set db = CurrentDb Set rec = db.OpenRecordset("select * from [Daily Run] Where field2 = '" & Me.list12 & "'") If (rec.EOF) Then rec.AddNew rec("field1") = Me.text11 rec("field2") =...

Actually saving it to another table with some added info. Thanks.

What is the correct way to save the values in a listbox column to the fields of a table? I can use rec("field1") = Me.list16.ItemData(Varitem) and that records the bound column to field 1 but how can I save the unbound columns to other fields in the table?

the row source for LISTBOX10 would be SELECT [table].field1,[table1].field2 FROM [table1] WHERE ((([table1].field2)=[Forms]![form1]![textbox15])); the row source for LISTBOX20 would be SELECT [table].field1,[table1].field2 FROM [table1] WHERE ((([table1].field2)=[Forms]![form1]![textbox25]))...

It's not really a "real world" thing. Just a curiousity of whether it would be necessary to write a query for every instance like that or if a single query could be made that could be used in every instance ang get the correct result. If the query was used as the row source for list box 10 it...

If I have a form with multiple list boxes, lets say named 10, 20 and 30. and multiple text fields called 15,25,and 35. Now I want to get a value in the list box based on the text box value so I make row source queries that looks like this. SELECT [table].field1,[table1].field2 FROM...

Oops. nevermind. Turns out simply refreshing the form on a button click does exactly this.

I just noticed that the Record selector bar on the left of the screen does exactly that but I'd prefer to make a button.

Good to know. Now I have another question in my quest to learn Access. I have a form where, when I click the button I want it to save the record but not advance to a new record. I'm sure I've done it before but I'm not finding how. Any ideas?

This is a simple yes/no field BTW. It's a simple toggle button, I am just wondering if it is possible to link link it to a yes/no field in a specific record.