Search results

I see, you can do two things 1) Use sharepoint or any other DB host to host your back end on. All your surveys could be linked in it. 2) Keep your backend local to you and have some sort of import feature, create a template DB to distribute as your survey

Looks like you need a back end/front end model. Are your surveys done internally (employees in your LAN) or externally?

This may help: http://www.techrepublic.com/article/eliminate-duplicate-records-with-this-built-in-access-query/1043732

You just have to initialize your strWidths Dim i as integer, NoOfChks as integer, strWidths as string NoOfChks = 6 strWidths = "0in; " For i = 1 to NoOfChks if Me.Controls("chk" & i) = -1 then strWidths = strWidths & "1in; " else strWidths = strWidths & "0in; " end if Next i...

I wouldn't blame it on Access just yet :) When exactly do you want the timestamp to be made? You can use the before insert Event for new records, or the Before update event for updated records.

You can put all your check boxes in one frame, and have the list columsn hide or show on_click event of that frame by checking which checkboxes have been marked. An event smarter way would be to label your checkboxes as chk1, chk2, chk3 and have a loop to check as below: Dim i as integer...

This is what I use, DSN not needed Dim cnxn As New ADODB.Connection Dim rs As ADODB.Recordset oConn.Open "Provider=sqloledb;" & _ "Server=myServerName;" & _ "Database=myDatabaseName;" & _ "User Id=myUsername;" & _ "Password=myPassword" Set rs = New...

Maybe this would help: http://www.vbaexpress.com/forum/showthread.php?t=35306

Me.RecordSelector = 0

I agree, makes this forum very unsuitable for work. Jon, please do something about this.

Nope, the bug is definitely in your code sir :) Check Module1 in the attached DB:

Why not just record printing Date & Time?

Sounds like you're in for an interesting project. I've worked on something similar a while back but the project got scrapped. Started with Aluminum sheets and ended with cans and paint buckets. SQL Backend with an Access Front End. It can definitely be done that I can tell you. The most...

We don't have enough information to determine where the error is coming from. The syntax seems fine. Test out DCount on its own first before running the entire code. You may have mis-spelled a field or table name

http://msdn.microsoft.com/en-us/library/office/aa193071(v=office.10).aspx Read about the HasFieldName property

Yes you can, what exactly do you want to achieve out of this? Try: Dim startID as integer, endID as integer startID =0 endid = 5 msgbox Dlookup("sum(Salary)","table1","ID > " & startID & " AND ID < " & endID)

Here's a good tutorial: http://www.ehow.com/how_13637_create-report-microsoft.html

Hi Deema, Why are you trying to print a form? You should only be printing reports. Build a report that would filter based on that primary key.

You don't need a loop, you need a query. And there's no need to duplicate your fields in a new table. Create a new query and put this in its SQL View: SELECT tblFreezer.PIN, tblFreezer.Freezer, tblFreezer.Time, tblFreezer.Fahrenheit, Hour(Now()-[Time]) AS ElapsedTime FROM tblFreezer WHERE...

Made a sample for you: