Search results

Before I start this is what I have encountered. SQL Server great backend but there seems a real hung-up about allowing the data to tell its story. You can take the data out of a relational database environment and then report on the information in Excel. Really! That sounds really smart. The...

Plog, Really good advice. I would add Tables > Reports > Tables. Get your reports right even if it means going back and adjusting the tables. One-to-many start the report at the many and Group on the one. Simon

Site are being viewed on mobile phones and whilst it is time-comsuming and not something to be rushed into by it would be great if there was some responsiveness, tablet or phone. After implenetating responsive sites, properly post deployment of the picture element if you take into account the...

Yes I agree, but there will be somwhere in the system where Financial Periods are stored. If they are wrong that is not our problem. But we can ensure that when a date is entered the correct Financial Period is assigned. The chances of making an error on 365 records as opposed to 12 are far...

Hi Doc_Man, The same applies to Stored Procedures. If you think about it everytime you want want the Month you need to loop through a Function or Procedure. I know this is not normalised but it you store Month you only have to loop through once and never again. Simon

Heres how I would approach the problem. Ididn't go down to line items as I was dealing with high value goods. The prinicple would be the same. When processing the cash slect the invoice and display outstanding line items. On the line items store have a flag Status Paid = Y Part = P Unpaid =...

Picking up on what is considered normalised. I use Start Dates and End Dates and store the Year, Period or Week in the transactional tables. Everything is measured aganst Weekly, Monthly or Yearly performance so I don't think it is abnormal to store these values. Afterall all we are doing is...

I was reading a manual on SQL Server and they suggested reporting Excel and a forum suggesting SSRS is a new technology and SSRS should be used. Having written VB for web sites I would have been flummoxed without the knowledge of VBA. I believe sharepoint does not support VBA - big shame. But...

Glad to help. If you have a problem let us know. Simon

Try using VBA is actually isn't that difficult 0nce you get the hang of it. I'm patently aware that you did not want VBA but it is worth perserving with. I want to know whether or not the Producer Bonus has been created: Private Function Schemes_BonusInvoiceCheck() On Error GoTo...

There is another way. Use VBA to run a SQL statement after input by the user and if the count = 1 set a flag to PreTest if the count = 2 set a flag to Post or something along those lines. Basically this is triggered after a Save Record on the Form Close or Add another Record. I do this to...

I have playing cards to teach bridge. Heart King jpg 127kb png 274kb bmp 1024kb Most of the image is white so why map every pixel when jpg can deal with the white in blocks. Simon

An OLE image has previously represented a bitmap image, aka Objects as Large as Elephants. I have no idea why this format was chosen it is simply bloatware. Over 25,000 images @ 1000KB breaks Access. I know that there are only two images but it is inefficient to store blobs in a database. Simon

I dont this to dates: Function GetDateConvert(SearchDate As Variant) As String GetDateConvert = Format(SearchDate, "mm/dd/yyyy") End Function I just create another Function if I need to convert multiple dates. Simon

I would use external referencing of images. There is nothing to stop you embedding images but we are developing databases not housing blobs (binary large objects). Simon

What really matters are the underlying SQL Statements. Understanding SQL statements matters to what and how the information is rendered. I may be corrected but SQL Server parse the SQL Statement second to last and internally defined Expressions cannot be used whilst Access Expression with a SQL...

Perhaps you could try a different approach. Forms? Have one form display at the Grouping level and another at the Detail. On the Header have two Command Buttons - one for Detail Form and another Detail Report. This way you can drill-down on each Grouping Level. Simon Simon

I put the selection in a pop-up form before the data screen and filter the latter using the selection from the pop-up and have a Another Selection to go back and open the pop-up (which is hidden). Simon

It matters not what depository you use. Even the Jet or Ace Access files. The real issue what language you are going to use. PHP / ASP.Net. You appear to be only posting Product details so chose a web development you are most comfortable with. There is always Sharepoint and perhaps Access...

The difference between a List and a table driven Combi is that you can edit and modify the Table without touching the form. A list box resides on the form only. Simon