Search results

The front end is timesheets_mgb.mdb and the back timesheets_be.mdb. I've embedded several tables in the one be file to simplify, and left in all the times and job nos but updated any identifying text to something nondescript. The button "Time Sheet" opens the Form where jobs are logged and...

Thanks - I thought Id sound people out first rather than assume that anyone would look. It will also take a little time to sort out how to send it, as its split, and Ill need to strip out confidential stuff thanks again Matt

Hello a couple of years ago, I wrote a flexi-time recording database that myself and a few other colleagues use. Times are logged against jobs *(held in another database) and a balance is calculated showing a credit over 7.4 decimal hours per day. This credit is capped at 7.4 hours so a user can...

Thanks for replies, I have it running now. The database is used by up to 20 people, and is split front and back. For the procedure to run on every start up is excessive I think (especially as it is deleting out and then writing a table of several thousand entries each time), but it does need to...

I have used a function I found here http://allenbrowne.com/ser-59alt.html and I have a very simple question on how to run it. The instructions show me how to run that function (and include subdirectories) by using Call ListFilesToTable("C:\Data", , True) from the Immediate window (with which...

The form is based on a parameter query that uses values from a preceding date choosing form. I needed to combine data from different queries running off the same parameter query and using forms rather rather than cross tab gives me more control. As I needed to use unbound controls the form...

Hello. I have (for me) a complex form containing 11 subforms, 26 visible unbound controls, 4 bound controls. I want users to be able to export the form into excel with a few clicks. How do I achieve this? In doing a little searching it looks like Im going to have to use VBA to map controls to...

Bob, Thanks very much for that. I am very much in the non meaningful PK camp. This was learnt the hard way, and I wouldn't have it any other way now. Thanks again Matt

I have now got further with the design of a database for recording the construction, maintenance, inspection, licensing and gauging of commercial craft on the English/Welsh inland waterways. I have a slight concern over the potential number of records in some of the tables, and want to ensure...

Thanks for replies folks. It seems to me that the most important element is whether or not we want to do any calcs on these dimensions in the future. Stored as 3 separate fields they could be concatenated for smoother presentation and the feet and inches fields would sort easily enough, but I...

Hi. I am designing a database for the compilation of UK boat registration, gauging and carrying information from the 19th and 20th centuries. In the journals to be transcribed, boat dimensions are recorded in feet, inches and fractions of an inch. I need the data input to also be in this form...

Id like to include a text box on a form showing the location of back end data. Ive found the way to list the current database location with data source as =[CurrentProject].[FullName] Can anyone advise how I could use something similar for a linked table? Thanks Matt

Aha thanks - a little button in front of my nose all the time. I dont tend to look for buttons to do things - I tend to assume that if an option is there, it will be there in a drop down command somewhere, and may well be duplicated as a button. Must be getting old. cheers Matt

I have 2007 (accdb) database into which I have imported forms from a 2003 (mdb) version. On the imported forms, I find that I am unable to ungroup previously grouped controls - the Format options (Tabular, Stacked, Remove) on the ribbon are greyed out. This problem has some similarity with the...

I have got round the problem by setting up two dsums on my form, running them through Nz functions, and then deducting one from the other in another control - this gives me the running sum that I was looking for. There is a little lag as it is calc.d, but it works. Matt

I now think that I need to use DSUM to create my running balance. I have used =DSum("RunningBalance","Q_Running_Balance","txtYearMonth=Forms!F_Daily_overall_Time_Sheet!txtYearMonth" And "ConHoursDate<Forms!F_Daily_overall_Time_Sheet!ConHoursDate") but this is giving me an overall total from...

Thanks Ken. Doh - will give it a try when I am back at my desk tomorrow. I was going to add that my control "txtyearmonth" is a value that I create by using "Year" and "Month" functions on the date field, and then combining those using "&" to make "txtyearmonth" so that 20/09/2008 becomes Sept...

I wish to calculate a running balance on a form. The sum is the sum of hours worked over contracted hours within the same month as the current record, and with date values previous to the current record. I have a query "Q_running_Balance" that holds the balances I am using this in the text box...

Thanks Rabbie - yes that works fine. I subsequently found that by applying a format to the individual dates in the queries of "yyyymm" (in the properties box of the field in the query) this has worked OK (although I need to be consistent in applying the formatting to the field, or the date...

We are exporting to a separate archaeological stratigraphic analysis package called "Stratify" that uses Paradox tables. http://www.stratify.org/index.htm I'm not clear that the version of paradox is relevant. When I tried exporting in different versions, the same file name truncation...