Search results

Hi all, Just a question which i hope you can help me with. If i create a Table "tblMessage" with the following fields "Username" and Message". Within the above table there is a message for username() "smithj" how would i get the contents of that message stored in the above table to be shown on a...

Hello all, I have a problem that i would be grateful for some help with. I have a form which is called frmMasterNum which has 3 Textboxes called txtFrom, txtTo and txtTotal. What i am looking to do is if i put "10010" in txtFrom and put "10015" in txtTo when i press a button the above numbers...

Hello, I was wondering if someone could take a look at my problem as i as struggling to come up with a solution. Is it possible to restricted the possible options available in a Combobox dependant on the value shown in a TextBox? Eg: A form called "frmmaster" has a Textbox called txt01, there...

Hello, I have an issue with a If statement that i have wrote, it is looking at the system time which i have set using the correct format but i get the feeling i have other looked something very simple. I would be gratfull if someone could have a look and feedback any suggestions. If Me.txtTime...

Hi, i have looked on the forum for this and i am slightly confused as it look like either you need to add a module to preform this action or a Union Select Query?? and i am not sure if i am looking at the correct Posts. What i am trying to do is on a form with a Record source called...

Hi, I have had a look at other posts on which i have attempted to create a IIf statement in a Query but it will not run. It shows a error message saying about the bracketing or a syntex error. I would be grateful if someone could please have a look at it and lend some knowledge to me as i am a...

DLookUp???? (Someone please help!!!!!!!) Hi, My problem is that i have a form which is used to book dates against a employee. I have a SubForm placed on the form that shows all dates currently booked against that employee, which automatically populates when the EmployeeID is entered into the...

Hello, I have looked and looked at all the delete statements on the forum but i am not getting anywhere fast. I have a table called "tblMaster" With the following fields that i want to search by IDNo DateRequired DateBooked In short i want to search the table and delete all duplicates where...

Hello all, I am new to Access but with that i side i want to learn. I have created a Database that collates defects. The Primary key is called "DefectID" which takes its number from a defect form that is never repeated. Unfortunately ever so often a person will try and input the same defect...

Hi i have a Textbox called DateTimeGiven which CONCATENATION the Date and TIME: =[DateDefectGivenToEngineer] & " " & [TimeDefectGivenToEngineer] and another one that does the same: DateTimeReported: =[DateReportedToRepairServices] & " " & [TimeReportedToRepairServices]. I am trying to find the...

Hello, I have a table of records which i need to filter via a query to show all data for up to 7 days from the day the query is ran. This in its self is simple using a Date()-7 function but i only want to show records that start from the Sunday within the date parameters. For example if i ran...

Hi, i have posted this question twice with 38 views and 0 replys so please have a look as i really need help but if you cant help than thanks for looking anyway. Original Question I have a reports menu were i can select which report i want and press either preview or Print. The problem is i am...

Report Problem. Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Hi, I have a reports menu were i can select which report i want and press either preview or Print. The problem is i am trying to creat a button and command that will send the selected report via email (Send Object) I have attached the...

Hello i have three combo boxs on a form which are linked to a querie. I am trying to find a way that if i do not select anything from the dropdown menu in the third combo box it will by-passes the Critiria and show all of the information unfiltered. Any Help!!!!

Hi all, I have a querie that pulls together two tables, i need to filter the querie using what is selected by using three perameters in Combo box's. I understand this is simular to a cascading querie but its not one as the value's of the combo boxs does not alter in anyway after the previous one...

Hello all, I am sure what i am asking is very simple but as i am a mear starter in the world of Access your patients and wisdome is required. I have a table called "Master" with multiple fields but this question revolves around just two of them. I have a field called "Vendor" and a field...

I all, I have a Textbox called "Cost" with is set at currency format and a Combo box called "Status" which has two options "Open" and "Closed", (Default value of "Open"). What i am trying to do is when the cost is changed to anything greater then £0.00 the Combo box changes it's value to...

Hello i need your help, I am using a sort string to show only the month of a date "Month: Month([ArrivalDate])" It returns a number as a month eg April reads as 4. I need it to return the month as it is shown on the table. The format of the Date is dd-mmmm-yy. Any help would be great

Hello all, Just a quick question, If the date of an entry is stored on the table as Long Format (dd/mm/yy hh/nn) but if i run a report i want all of the entries to be grouped per month? Also i want the grouped entries to have a header that is labeled as the month name. Any help would be great...

Hello, I have created a Database and are assigning Users to it, the easiest way i see to do this is set them a AccessID (Admin = ID1, User =ID2, Temp =ID3, Guest = ID4) I have 4 buttons and depending on what ID the user has will bepend on whether they can press the buttton as it will not be...