Search results

If the new created query is saved in the individual's frontend file on their computer, then the other four users would not see it.

Thank you Galaxiom. All users have the same frontend (#1 or #2) on their local computers. If a problem exists with two users (frontend #1 and frontend #2), and they have the same network permissions, do you have any suggestions as to what the problem may be?

I have two backend and two frontend databases. These were developed over a period of time and were not integrated for various reasons. TableA (in backend database#1) is linked to both frontend databases. When user#1 of frontend database#1 has a form open that is bound to tableA and user#2...

Any help on how to design archiving of records would be greatly appreciated. Thank you.

I have a table of "people" and want to designate some of these as "speakers." Is the best design to create a field in the "people table" to do this or to create a second "speaker table" with the key of each speaker in the people table?

If there is more than one value when using DLookup(), is there a way to concatenate those? Thanks!

I have three tables with data. Table1 is data for meals. Table2 is data for room costs. Table3 is data for payments made. Each of these tables has a foreign key for EventID. I'm trying to produce a report that will show, for each EventID: The total billed (which is meals + rooms) The total...

I have a subform and I want to save the username to the bound table in this subform. I've tried creating a textbox (CompBy) and then setting the default value to = Environ("UserName") but this doesn't work. I've tried placing the following in the afterupdate event of the subform...

Thank you Mihail. I think I figured it out.

I'm creating a string with an IIf statement and placing a comma between values. How do I delete the last comma at the end of the resultant string? Thank you!

Is it possible to list out each consecutive date in a report when given a range of dates without having to create a table of dates? For example, given the date range 12/01/2013 to 12/05/2013: In report: 12/01/2013 12/02/2013 12/03/2013 12/04/2013 12/05/2013 Is it possible to do this...

I have a form with multiple subforms. I want to display the totals from two subforms in a third subform and can't seem to make it work. Do I calculate using the values in the subforms or in the tables? Thank you.

Thanks CJ. The BE has default settings...opens with sharing, etc.

Not sure if this is the correct forum but... I have two BE files that sit on a file server in two separate folders. I have two FE apps using these BE files. Each of these FE apps links to a table of customers in one BE file. When user #1 opens a form using FE app #1 with record source set...

Private Sub cmdAddEvent_Click() Dim dtCriteria1 As Date Dim strsql As String Dim lngID As Long Dim intAnswer As Integer Dim rs As Recordset Dim dtStart As Date Dim dtEnd As Date Dim strOrganizationIndividual As String Dim res As Integer Dim lngNewID As...

Oh...I'm so sorry...I meant Paul.

Thanks Peter. I'm using Access 2007 for both databases. Database2 is an old database that began in Access 2000 and was updated to 2007.

Thank you Paul. When I try to add Microsoft DAO 3.5 or 3.6 Object library it says it conflicts with existing project, module or object library. Why would it compile in database1 and not in database2?

Mihail: I have the following references for Database1: Visual Basic for Applications Microsoft Access 12.0 Object Library OLE Automation Microsoft Office 12.0 Access database engine Object Microsoft Outlook 12.0 Object Library Microsoft Calendar Control 2007 For database2 I have the above...

I have a form in database1 that compiles and works OK. I copied this form into database2 and the form will not compile. Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("tblReservation", dbOpenDynaset) The code that will not compile is: .Bookmark =...