Recent content by gotlength

Here's what I ended up doing in case anyone needs ideas.

Hi, I need some help on designing a form for a event meeting schedule. It needs to display the days of the meeting and what lectures are taking place that day. Like: Meeting information form | | | Days subform Day 1 | |Lecture subform Intro to access Mastering access .. Day 2...

If you want it to do it real time as they type make a function: Public Function properCase(keyNumber As Integer, str As String) If Len(str) = 0 Or Right(str, 1) = " " Then properCase = Asc(UCase(Chr(keyNumber))) Else properCase = keyNumber End If End...

I'll have to give it a shot. I'll let you know. Thanks

We run meetings, so one example of where I will need record locking is if employee #1 is doing a follow up for a meeting and they are changing say how many hours a customer attended at one of their past meetings. Then the customer calls in starts talking to employee #2. (employee #1 was not...

If I were to use adodb and SQL Server OLEDB, doesn't that bypass ODCB? I've tried using the following code, but it still doesn't not lock an edited record. Private Sub Form_Open(Cancel As Integer) Dim cn As ADODB.Connection Dim rs As ADODB.Recordset 'Create a new ADO...

Thanks for the help. Would it help at all if I used ADO or DAO instead of ODBC? This is my first time using Access and SQL, so I not sure what would be better. Thanks!

Did you figure out a solution? I have the same problem. I do not want a person wasting tons of time entering data only to find out they cannot save it because it's been edited by someone else since they started.

Did you figure out how to do this? I need to know how to lock the record also.

This is going to be a really stupid question. But how do you open a table, form, or report when the navigation pane is hidden? I'm not talking about in vb. When you go to file - open, it only lets you open a database. Thanks!

Thanks for the link. I'm trying to store attachments in the database from access. I could use filestream, (which I don't know how to do yet), but I figure that filetables would be a better option.

Hi everyone! I'm new to the forum and I have found it very helpful thank you very much. I am also a newbie to access and sql. How do you use a SQL 2012 filetable in Access 2013? I can link the table in Access, but I get the error: "ODBC--cal failed". It then pulls up the table and I can see...