Search results

How are you checking installation date? You could write a date to a Table when first opened. Then every subsequent open check the difference between Now() and that Date. If it is 30 or more DoCmd.Quit or popup a Form for an Admin etc. Are you creating this as a .accde so that the code can't be...

Original Like "*" & [parametername] & "*" Try adding single quotes around the search. LIKE "'*" & [parametername] & "*'" I take it [parametername] is a String?

One way is to have all the values you need as hidden textboxes on your main menu. Never allow this menu to close unless you exit the db and it will always be available to you. So you have your login form, when they successfully login set these hidden values to the various values associated with...

Not sure what you mean. You mention positive/negative which I would think would mean you are talking about a number but you have highlighted a field containing text. Could you give an example of what it is now and what you want it to actually look like.

You can create a Query that uses a Parameter, the Login name on the Form to filter for that. http://www.599cd.com/tips/access/forms-formname-field-notation/?key=AlexForum

So you wish to store every file attached even if it was incorrect? I'd not store them as actual attachments (this can bloat the db) but instead path/filenames, with a date added, then you could just display the newest file. If you do want them as the attachment field just have a separate table...

http://office.microsoft.com/en-gb/access-help/import-export-and-link-data-between-access-and-excel-HP001095095.aspx http://office.microsoft.com/en-gb/excel-help/connect-an-access-database-to-your-workbook-HA102840045.aspx

Why not just make it a Trusted Location as this is the error you are receiving? http://office.microsoft.com/en-gb/word-help/create-remove-or-change-a-trusted-location-for-your-files-HA010031999.aspx - - - If you can open other files it might not be necessary but Map a drive...

Are you having any issues with other files stored in that shared location on the machine? Could it be the mapping, might it be worth remapping the folder?

Happy to help :)

This may point you in the right direction. Using DateDiff and DateAdd to Determine Differences in Dates http://www.599cd.com/tips/access/dates-datediff-dateadd/ You could work out the difference then use an Aggregate function to work out the Average.

You could create an UPDATE Query to change the number in a Table based on its ID. http://www.599cd.com/tips/access/update-query/ http://office.microsoft.com/en-gb/access-help/update-data-by-using-a-query-HA010076527.aspx#BM4 UPDATE table SET newvalue WHERE criteria; - - - For the second...

Message = "Hi" & [Customer Name] & "Thanks for your booking on " & [Booking Date] & "etc etc..."

You need to do string concatenation. Use the "&" to join Strings and Variables/Fields/Controls Dim strMessage As String strMessage = "Hi " & [Forms]![frmFORMNAME]![FIELDNAME] & " more words"

What error are you getting? Is the Shared Files Folder a Trusted Location, if this is a safe option for you to do?

Yeah I would create a central Table that has common Fields that all use then create separate Tables with the extra Fields needed. You could create a 1-1 Relationship and only allow certain users to add records to them, therefore they will only be created when necessary.

So do you want whenever you add a record for the Date field to say the first of the current month? How about using DateSerial? Set the Default Value either in the Table or Form. DateSerial(year, month, day) http://office.microsoft.com/en-gb/access-help/dateserial-function-HA001228813.aspx...

Cross Post: http://www.accessforums.net/showthread.php?t=40128 Info: http://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters

If you remove the WHERE does it return records? SELECT log.*, UL.langue, UL.version FROM log, (SELECT list.id, list.[langue], list.version, list.no_joueur FROM list GROUP BY list.id, list.[langue], list.version, list.no_joueur) AS UL Does the inner SELECT return anything? SELECT list.id...

http://accessblog.net/2011/10/how-to-link-foxpro-tables.html?m=1 Set tdf = dbs.CreateTableDef(strTableName, _ dbAttachExclusive, _ strFileName, _ "ODBC;DSN=Visual FoxPro Tables;SourceDB=" & strFolder & _ ";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;" & _...