Search results

If I define 'Dim db AS Object' or only 'Dim db' which will be a variable type, program works OK and compile successfully. It does not work when I rewrite as 'Dim db As Database'. Does it make a difference if I define db as Variant or Object type please? Product is advertised for Access 64-bit...

Thank you DocMan. Actually I've purchased a small utility over the internet to put restrictions and username/password mechanism for MS Access database. It is called LASsie (Light Application Security) and is available @ http://www.peterssoftware.com/las.htm I've tried to contract Mr. Peter from...

Hi, I could not load ‘Microsoft DAO 3.x Object Library’ for Access x64. I can see the required DLL file, but when I try to load it gives me ‘Error in loading DLL’!! I need to get this fixed to work with some older DAO code. Could not get enough help from internet to sort this out. Jet...

Really thankful CJ, at least able to work in US format. Access dates are really a trouble to work with. How am I gonna deal with other date formats please? I am gonna use the same program to other regions as well. However, I still have to use DateValue otherwise time value will not let the date...

Thank CJ, I’ve understood and changed. Now I can’t prevent duplicate values sneaking into the database table tblEmployee_WorkPack and tblEmp_Clocked_Time. I’ve applied the correct logic but DLookUp doesn’t seem to work fine and returning NULL, and failing the condition everytime. Everytime which...

Ok, this is how I made it work. Pasting, but also attaching screenshot with an error message. link to previous thread on this: http://www.access-programmers.co.uk/forums/showthread.php?t=287026 I'm now able to put date/time in database in correct format. Now when I try to confirm that program...

Thanks, but it hasn't work! K

Thanks, RuralGuy. It has improved my understanding about how Access deals with dates, but how to deal with the issue. I'm using European times settings. Thanks, K

Hi, According to the requirements, I've to assign Supervisors to a job for specified dates. When I'm trying to do say via VBA, it is saving in a wrong format and i don't understand why it is happening. Attaching screenshots of, data Form itself, how it is saved the table and screenshot of...

Thanks, sorted my problem. Never thought of it!! Why it happens by the way, if you don't mind sharing. Thank you, K

Where's the syntax error in this DLookUP Query please, when there's a NULL value in WorkPackID field? If it is NOT NULL, it works fine. DLookup("EmployeeID", "tblEmployee_WorkPack", "WorkPackID = " & Me.WorkPackID & " And DateValue(Assignment_Date) = DateValue(#" & Me.Assignment_Date & "#) And...

Just seen that I never thanked on this. It helped me solve one of the biggest problem i was facing for quite a time. Basically, application of point # 5 solved my issue alone, but later I improved Indexing based on point 2 and learned something new from point 3. Thank you.

Though achieve what i was looking for, but report runs quite slow because of many queries running on the same report. Thank you, it solved my immediate problem ) Regards, K

Yes right, but I give up. I've spent full morning with no results and now I've ran out of ideas. I'm uploading striped down version of the database. There are related tables, queries and couple of reports which i need to sort based on initial discussion. I'm really grateful for your help. Khurram

I understand what you're trying to explain and it is a lot easier than what I'm trying to achieve. But I've been told that this is the standard reporting format we're using in the company for such reports. So I've to make it work somehow ( Attaching the format that i'm trying to acheive, but...

Thanks JOC, but how would I build several level of calculations (Project Manager, Supervisor, Area and WorkPack) in a query. Do you meant you say that i run 3 - 4 queries, each at every level and then stuff them in respective headers?? Thanks. In short, we have 4 levels of grouping. At 4th...

hi, I'm trying to calculate in a control, in Reports, based on another calculated control. Getting no error, but asking for a value in an input box when i run the report. In another scenario, I'm trying to put aggregate function in another aggregate function, but is not working as well...

Thank you CJ, got the problem sorted by the hint u provided and later applied the manual formatting )

Thank you CJ, for clarification on double. I still could not get it through right properly. I'm attaching the sample Excel file, based on original file I used for exporting. It'll be great help for now and future, if could be helped in sorting this. Thanks.

maybe it is not working for me because I'm importing Text type data from Excel sheet into General Date/Time field in Access. Attaching screenshot. Screenshot shows that i am trying to concatenate ActivityDate and SignedInTime columns in Excel sheet to a single Date/Time field. End result is a...