Search results

I believe ‘Windows RemoteDesktop' is windows version of TeamView? Citrix/Azure look a less straight forward. I am drawn towards WindowsRemote/TeamView type solution, I think I can live with the user limitations and I can implement it quickly. What steps do I need to take to ensure best practice...

Big thanks to MajP.

Does anyone have any experience running an Access application online. The problem I have is I run an Access database that is central to the running of our school for children with significant emotional difficulties. All was great back in prehistory (February) when all staff and students were on...

If any one stumbles accross this thread I did find a solution (which is very much in line with The_Doc_Man's suggestion), in the end I sorted my problem with a brute force method as I do not expect it to be a recurrent problem, the truth is the best solution to these problems is not let them...

Hopefully it won't happen often, I'm going to try theDBguy's solution mainly out of interest, for today's problem brute force I think it is. Tah

Lucky I did which is a big surprise as when I started this project many moons ago I did break just about every golden rule out there. I was hoping for something a little more automatic, it is obviously in access somewhere because when you delete cascaded records access finds them all. However...

Hi I'm doing a bit of house cleaning on a project I use to manage school data. I have come across a duplicate record in my student table (i.e. same student entered twice each with its own auto number PK). Obviously I want to delete one but before doing so I wish to check the PK hasn't been used...

I'm guessing the undo command is leaving the form in a state it doesn't like, i.e. something like a required field is is empty or something isn't valid. I think I'd comment out the DoCmd.Close line and see what form looks like when you go back to it, i.e. do any of the controls have contents...

It is a little long winded try If msgbox("Přejete si uložit data?", vbYesNo) = vbNo Then 'no button selected DoCmd.RunCommand acCmdUndo DoCmd.Close Else ' The yes button was selected. DoCmd.Close Globals.Logging "Zapujceni" End If Should work and is easier to...

That looks just the ticket. My follow up question was to be how to edit links without the relationship window but you've answered that before I got there. Many thanks

Hi I have a database that has grown to have over 60 tables and a considerable number of relationships. I want to review the relationships as when I started this project I didn't really know what I was doing and want to go back and check it is all robust. When I go to look at relationships I...

reset score to zero each time you login and restart quiz from Qu1? or have a table that records each players state, each time they answer a question update question number and current score, when they log back in quiz starts back at same question with score. or ban cheats

opps Gasman is absolutley right the dates are strings (I think I copy and pasted and older version from my notes) He's also right about copious use of Debug.Print, it has helped me loads to get from being completely useless to being almost useful. It is especially handy when concating strings...

If have use this many times, never let me down. The problem I had with dates and access was understanding in SQL dates need to be strings in format "#mm/dd/yy#" Dim date1 As Date Dim date2 As Date Dim filter As String date1 = Format( ????source of date1 , "mm/dd/yy") date2 = Format(...

This is easy enough to do with an append query as bob suggests, but why do you need to? unless you are deleting data from originating tables this would just duplicate data? You can recall your history anytime using same query.

I have tried query def, but I can't get my head round them, if you have a link to a guide to query defs for the old that would be good. On this particualr issue I have a soultion by a different means. Basicaly I have taken the WHERE clause out of the SQL (and hence the parameters) and then use...

Same response - read something that using recordsets as recordsource is a bit of a no go in on reports in access (forms seem a bit more friendly)

Hi, Thanks for your thoughts That was ine of the many things I tried, my code in the report 'on load' eventwas strSQL = " TRANSFORM First(tblLessons.subject & .......... de da de da (the SQL works) Set rs = db.OpenRecordset(strSQL) Me.Recordset = rs Then I get

Would it be easier to use a text box with a date format and use a date picker rather than type date in?

Hi I have a report which I want to use a CrossTab query with parameters as the recordsource. I have found that the only way I can get the parameters into crosstab query is in code (no problem there), but I cannot get the SQL accepted as recordsource. e.g. me.RecordSource = strCrossTabQuery...