Search results

yeah thanks for that ansentry, i was almost there had managed to get it to work if i pointed to a textbox on the form and used gotfocus procedure. Works even better with oncurrent, the only thing i could of been missing was that bit or error trapping i guess, cheers once again

Hello in the grand scheme of things i would like to achieve the following, Have a main form with a continuous sub form[1stSubform] linked to it. I then have a second continuous sub form[2ndsubform] located on the main form, I would like to link the values of [2ndsubform] to the value selected in...

Ok that would be something im looking for, it would be a better user interface if i could then suppress the built in message and give them a message of my own. ANy ideas how to do this?

would you do this in the table design by setting the default value to something like [stairID] & [inspectiondate] ?thanks

I would like to check to see if a previous date value has been entered for a specific record and display a message if it has. I have spent some time researching vlookup and vcount but im not quite there in what i want to achieve. I have a data entry subform, linked to my main form through...

I would like to calculate the time difference between two dates, what ive got so far is TimeSpent: DateDiff("n",[datein],[dateout]) This calculates the minutes between two dates, Can you format this so that it calculates hours. minutes for example 124 minutes would be 2.04? I thought using...

Hi, ive been trying to develop a more advanced help file with helpscribble. I have created the help files, compiled the files etc, my question is how do you get it to link to your database? I was just under the impression you set your project to call it from the vbaproject propeties, set which...

After doing a little research this does seem to be the case, if this is true I would expect access to miss out the last 3 reports in question, instead it seems to miss out subreports 7, 8 ,9 rather than 9, 10,11 Also I had this posting by someone yesterday "You can also use the ReportHeader...

I have a report that is made up of approximatly 10 sub reports, if you open the report in print preview all the sub reports and records are visible, when you print the report however somehow an access gremlin decides to exclude 3 of the reports out of 10, thus only showing 7 of the sub reports...

Hi Ive done a quick search to find out about making a page break visible depending on whether a sub report has any data in it. I need different sub reports on different pages, i have put the page break after each sub report, the problem is if the report has no data it just shows a blank page...

I was having this same problem at the start of the week, now touch wood it seems to have gone. The only thing i can think that ive been doing different is instead of using the chart wizard ive opened a new report in design view and selected approriate query, then dropped a chart onto the report...

Just reposting this message because i'm having the same problem, anyone know what is going on with this irritating problem

have a look at the dateDiff pieces in the help files

I have a query based around a persons sick start and return date. A report is based upon this and then this makes up a sub part of management information report that is linked through a formatted month. Part of my report is based around the following formula, this governs which MI report to...

Yeah it has to be within the same month, perhaps i should be looking at fufilling both criteria however, will investigate now

I will try to explain my problem as best i can and would appreciate any thoughts other people have on it, it is surely similar in some degree to someone elses previous work! I need to produce management information on a monthly basis, one example of this type of work are an employees one to...

I have been doing some research on the currentuser() function and basing events on its value. I have been testing around the following If CurrentUser() = "manager" Then Me.tabHide.Visible = True End If My understanding is that if a user called "manager" is logged in the tab will...

I have been doing some research on the currentuser() function and basing events on its value. I have been testing around the following If CurrentUser() = "manager" Then Me.tabHide.Visible = True End If My understanding is that if a user called "manager" is logged in the tab will...

I have been doing some research on the currentuser() function and basing events on its value. I have been testing around the following If CurrentUser() = "manager" Then Me.tabHide.Visible = True End If My understanding is that if a user called "manager" is logged in the tab will...

Why would they want to base reports from tables? :confused: Because they have limited intelligence! Cool thought was best avenue to go down, thanks