Search results

Thanks pr2-eugin, for the suggestion. It would take a while to strip my db, since it is splitted. I will certanly do it, if I won't be able to solve it elsehow soon. I had some other things to do, but in the afternoon (GMT+1) I did some investigation. The wrong records in the table are actually...

I have encountered a very strange phenomena, which shocked my confidence in Access, and reminds me very mutch to excel! I have a table with an indexed (No duplicates) text field as primary key. The values are actually numbers, but I have chosen the text format to keep leading zeros. Today I...

Thanks Mr. B, your reply have put me on the right path. I learn a new thing here every day.

Hello all, First, let me explain the task I want to accomplish. In my tables I have a field called first serial. This is the first element of a serial number range associated with each record. Very rarely I have to ask the user to specify a certain serial number in that range. (The serial...

Ah THX! What a trivial mistake:o You are right, the two dates were the same. I've spent 2 hours, but could not notice this. Than you all.

Thanks for the quick reply! Those functions are very simple too. sftd is a combo box value on a form, and can have 3 values: shift names in hungarian (morning afternoon and night). sftd is a Date value from a textbox control (set to Short Date format) on the same form. Function sftstart(sftd...

Hello gusy, Can somebody point out the mistake in my function? It is basically a DCount, and it should find records, but returns 0 all the time. My code is: Function cntkit(sftd As Date, sftn As String, typid As Integer, specpaint As Boolean) As Integer 'Counts jobs kitted during shift given...

Hello guys, I am trying to set up a calculated field in one of my form querries, using expression builder. In one of my source tables I have 4 date fields called Inspection date 1 to 4 I need the lowest date among those inspectinos which are in the future (next inspection) If all 4 dates are...

Hello guys, I have started to develope an access database 2 months ago, when it became clear, that the data management system based on multiple excel files which were in use at my workplace (also developed by me) will soon be way over the intentions and capeablilties of Excel. I have...