Search results

I have a form "FrmMaintenance" based on the query "QryMaintenance" that is taken information from the table "TblMaintenance". In the form, I have to pull the serial number of a machine from a drop down list which works perfectly fine in the form and it also updates other associated records...

Hi there forum, I really need your assistance with this problem. :confused: I have a table (tblInstallations) which has records of date installed (for machines). It is calculating that "next due maintenance" is one year after installation. Sometimes we need to visit the site to maintain or...

:( Hi there guys, I have added an attachment button to a form. Everything is working fine. I was just wondering if I can add a security like a password to this button (Attachment) that would prevent users without permission to get to see the attachment. When you click on the button you can...

Hi there guys, I am trying to open a form with some records taken from one table, then alter couple of data in it and after that most importantly to append current records into a different table. The reason I need to append is that I need to keep track on every occurrence on same fields. It...

Hi There Forum I'm back again with the need for your much appreciated assistance. I have this table "tblPreventativeMaintenance" which calculates when the next appointment for service. Stored in the field "NextDueService". I have three fields in this table. "SerialNumber", "NextDueService" &...

Dear All I have this combo box in a form which picks up data from the table. Auto Filling other records. It fills up 4 records with data. I've set up the column head to "yes" so I can see names of the columns I'm picking up. The name on the head of column shows the name correct, which is...

Hi guys of the Forum I managed with your help to make a new control checks two records and displays the largest of them. You adviced me to put this in OnCurrent() event. It did very well and was working fine until I added a new record that picked up both days automatically (auto fill)...

Hi there Forum In my Form I have an "Option Group" which has 5 radio buttons or option buttons. The option buttons are there for the customer to pick up number of years to buy extended warranty. I have managed to work out how it works and adds to the existing "DateExtendedWarrantyTaken"...

Good day Forum :) I have an "ExtendedWarranty" that is calculating ([DateExtendedWarrantyTaken] + [NumberOfYearsExW] * 365) DateExtendedWarrantyTaken =Date(). This is working fine until "InitialWarranty" exceeds "DateExtendedWarrantyTaken". I need your help guys to set my extended...

Hi Forum I have two date records that I need to check if first one is larger or equal then display the first date, otherwise to display the second in a new record. :confused: Many Thanks Abbosy

Hi there guys :) I'm trying to set a query with 6 fields. My question is: Is it possible that the query shows me a combo box to select what is connected to this data. :o Example fields: HospCode; HospName; Dept; ModName; SerialN; DatInst I'm looking to select name of a hospital from...

Hi there Forum How to get about to make a form opens a new record when loaded. Really appreciate your help guys. Thanks a lot :)

Hi there Forum :) Can a Form/Query warn when a date is approaching; like in a pop up or any other behaviour? :o Many thanks

Hi there everyone I need my Database to have an access/front page that I can use it as an entrance for the user to select where they want to go or what to do after. It's like a page that I supply it with buttons to access all/most the forms in the database. How can I go about this and what is...

Hi there nice forum :cool: The problem I'm facing is like this: I have a table called "Cities" which has only two fields; City & Province. I have connected it in a relationship with another table as "Include ALL records from 'Cities' and only those records from 'tblInstallations' where the...

Hi there community My form which is based on a table carrying same name doesn't append the full length of the text to one of the fields. I don't know where the mistake is occuring or indeed I don't know if the error is in the table or in the form. The form is showing full length of the text but...

Hi to all I am thrilled to be accepted in this forum of professionals who discuss and help the community of Access users reach their goals in making nicely working and professional databases. I live in the UK, London and work with a company selling products abroad. My role is to set couple...