Search results

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

I am told there is a patch which allows 2000 databases to work in 2003 os without any problems. does anyone have a url to it please?

cheers I have an OLE field which I have put on a form and I can drag and drop files onto it from outside oif access ie from my documents, obviously this involves have both the form and My Documents open on the screen in order to drag and drop onto the ole field in the Form. What I would like...

I would like to have a file explorer on a form so that users can navigate to a file and drag'n'drop it into my OLE field on the form. what is the activeX control called that give a file explorer? Or another way for users to add files MSaccess 2000!

Thanks, I pasted that into the on open property of the subform but get this error Microsfot Visual basci Runtiem error '2046': The command or action 'RecordsGoToNew' isnt available now. END DEBUG HELP is this a code error or a missing library file

I am building a database for 2 Nurses and an Admin Lady to monitor treatment for Alcohol abusers that end up in A&E! It has 4 tables so far Patients details (PK=HospitalID) - Name/Address/DOB/Gender Hospital Admissions (PK=EpisodeID) - Date Admitted/who admitted GP Info (PK=GPID) - Gp...