Search results

Hi all I found this piece of code on a login form that I am using on my database. The issue I have is when I compile it, it gives me a compile error: "Expected user-defined type, not object" How do I fix this? Public Function SetProperties(PropName As String, PropType As Variant, PropValue...

Good day... I am hoping someone can assist or point me in a direction with regards to managing times in a database. Allow me to explain... I have 3x tables... tblHolidays which contains "HolidaysID", "HolidayName" and "HolidayDate" tblEmployees which contains "EmployeesID", "EmployeeName" and...

Good day I have attached a sample of my database here. the problem I am having is I have 2 combo boxes on my form which works perfectly. When I attach that form to another form as a subform, everything falls apart. I have tried to create a subform in datasheet and it doesnt work. I then tried to...

Good day all I'm really hoping someone can assist me. I'm trying to create a calculator using different sets of tariffs. Basically what happens is i will enter an amount of units consumed. What the calculator needs to do at the push of a button is calculate the amount owed by breaking the...

hi all im am using the microsoft access desktop inventory template at the moment what i have in mind to do is create another store with the same inventory, but i would like to merge it into the current database that i am using. in other words ... i have 2 stores. i have the same inventory in...

please can someone help me. i have a opened date[default value =Now()] and resolved date[default value =Now()]. i would like to calculate the time elapsed between the two dates. it is normally on the same day, but there are instances where it can run past midnight.

Can anyone please, please help me. I would like to make some changes to the Northwind sample database. it will work perfectly for me. I need to have the Customers section completely removed as my company issues products to our own staff, not to external customers, so there is no Customers and...

Hi I have a query (Inventory Transactions Extended) in which i am trying to caculate current stock. I have a form (Inventory Transactions Form) where i either add or remove Inventory Items. I have used this statement to create a new field (Actual Quantity) to calculate current stock based on...

hi so im having a bit of a problem. i have a number of tables...ie... tblcases: (title, assigned to, opened by, opened date, customer, status, category, priority, description, due date, comments, resolved date) tblcustomers: (last name, first name, email address, contact number, house number...

I have a query which gets information from 2x tables where the I'd on one table is the reference number on the second table. I would like to know how I can remove the duplicates on my reference number field?

hi all i have a table on my database from which i generate a monthly report by running a query. when i run the query (date from to date to) i have no problem. it shows me all the relevant records. when i want to generate a report, i input the start date and the closing date for the report. it...

hi i have 3x time fields in a table i.e time received, time started, time completed i need to accurately caculate the time between time received and time completed. whenever the time goes past 00:00 it seems to add 24 hrs to my calculated time is there a macro or code that i can use to rectify...

Hi I'm new to this programming thing. Set up a database at work at have received a lot of help on this forum, so just wanna thk all u guys from whom I got ideas and tips