Recent content by Singlespeed

has anyone got msaccess 2007 working in office 365? I have a database which is currently working on my employers server, with Vba controlled forms. would it be possible to upload it to office 365 and operate it from there?

I am sure this must be easy? access 2007 I have a table witha checkbox Yes/No field and I want to select just the "yes" or ticks in a query how can I do this?

As per title I have a table date field on a form using the date picker but I want the default date to be +5 days from the now() date which it seems to use as default. Can anyone tell me how to do this?

yeah - I was being lazy I have now done a report for it!

I would like a have a simple print out for my form In the header I have officer drop list and between date parameters that the 3 subforms all use on the form one subform displays cases open one cases closed and one live cases since the volumes for each officer vary from 5 to 40 rows I...

Bob Many thanks, that worked a treat, S

I am trying to run a report from a hyperlink row, I have got that far, but I want the report to open using the value I click on in its underlying query. I tried referenceing the form field "case" in the query but that didnt work:mad: Can you tell me a quick and easy way to do this? :confused:

sorry, memo field

Yes it is a message field

I have a simple query which works until I try to add a simple filter criteria, the results seem to get converted to chinese-ish characters - how do I prevent this, its a 2007 database migrated from 2003. the field causing the problem is ALN_REVIEW

I think my old VB that runs when I open the form is effecting the attachment dialog. this is what runs when I open the form Private Sub AddNewALRecord_Button_Click() On Error GoTo Err_AddNewALRecord_Button_Click Dim stDocName As String Dim stLinkCriteria As String stDocName =...

I have an attachment field in my table and I can see all of the dialogue buttons on the dialogue box but when I add the field to my form all of the buttons are greyed out and the only one I can click is "Cancel" How can I configure the attachment control on the form so that it works if I...

Can you tell me how I use the code to get the loginname to display in a text box on a form or how I can use it in a Query.

I want to "secure" my database so that just these 6 users can access it. Ideally I would use a form of NT authentication to match the userid to a list of user ids in a table. is there a thread with this already done?

sqlparse.dll is missing, on the 2003 install opening the 2000 database, but only on this database