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?

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...

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:

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 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...

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?

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?

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!

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...

I have a form with 3 subforms and I want them as view only and have separate forms to add/edit and delete rows, my question is how do I "lock" the fields on my main form?

I have pre christmas developers block and cant figure this out, it appears simple!! I have a table with Date Started Treatment, Date Treatment Completed going back 3 years. I need to produce a monthly summary for the last 12 months to show how many people were in treatment at the end of each...

I have a line chart with 3 years worth of months on the X axis (36 points) and I have a 3 year trend line. what I need is another trend line for the last 12 months, I have added a field in my data with just the last months data points but when I add a trend line to that one it goes right back to...

I have a line chart with 3 years worth of months on the X axis (36 points) and I have a 3 year trend line. what I need is another trend line for the last 12 months, I have added a field in my data with just the last months data points but when I add a trend line to that one it goes right back...

:o 2000 with MSGraph.Chart.8 I have a simple crosstab source query going into a bar chart and I want one line to use as target - I have changed it to the "classic Bar/line" graph type and I can change the colours fine, but I cant seem to control which fields use bars and which use lines - also...

I have 12 months worth of appointments and need to show totals per month so I make month/year with datepart "m" & "yyyy" but the months dont come in the right order on the cross tab. Has anyone got a trick to resolve this please?

I want to build something like this: http://gis.chicagopolice.org/ using access 2000/ MAPx 5.0 and Map info:( I have got all the street maps and Geo data I need, what I would like advice on is how to build a neat and funky GUI app for my end users to have an experience like the ESRI...