Search results

Hello I was asked to make a change in the code I am currently calculating how much a student should pay per day =IIf(IsNull([Form]![extday]),"0",[amount]/30*[Form]![extday]) where [extday] is the calculation of how many days the student was present in the month by the Diff2Dates function What...

Hi I have a problem I am trying to filter a query using the MAX function I need to pull results of the latest month and year in the records the year field is the number the month field is text (problem I know) in months 10 11 12 I get one record of each year in all the other months I Gets full...

hi: i'm not an expert in excel more in access i build a worker howers report i build a month and year changing automatically A=Current date in the month B= Current day name work time are fixed value a cell that wan i enter the month number the day change according to the date first how do i...

hi: i have a listbox 2 Column that get the value from a query in the form there is also textbox my vba code should change the background color of the textbox if some value exist in the listbox and if not set different background i have like a blank in my mind and i can't remember If...

hi: is it possible to print double sided 2 different report for now i'm putting the paper with one side printed and then print the report When the page is upside down my printer support Duplex Printing

hi: i have a workgroup with 5 ms access db(can grow) it's all LAN with 1GB there is 10 pc's(can grow) working on the DB. the backend tables are stored in one of the pc's my Q is i have to build a server no question about it my problem that i don't want Start messing around with windows server...

hi i have a form for insert students datiles on the form is failed name "studentid"(text failed) that have index what i need is when typing a new "id" the code well search if the "id" is already exists my code If IsNull(DLookup("[studentid]", "students", Me.studentid <> 0)) Then...

is there a way to show only the record that are close to now date for now i want to get around the "max function" i have a query that build from 4 queries one field called "caredate" i already used "max" in one query but im getting All the results (its ok) now i need to show only the record...

i have a field call "studentid" with no duplicates allowed im using (DAO) "with rst" "addnew" now it could be that the "studentid" is already in the system and when the code well run it well give run time error so i need to put error handler On Error GoTo ErrorHandler if "studentid" excit move...

I created a query from two tables, one of which does not have a primary key because of the need for duplicates. I know that such a query cannot be edited what I am used to do is to create a subform and then create the fields on the main form form![subform]![fieldname]so i can see it in...

hi: is there any way to drag and copy a field in design view most of the software use "shift" in access copy and paste dropping the field in the upper left of the form

i have a date field on a form where the data is coming from a table now i notice the in the table the field is empty(Serious employee failure) i can put any date that i want in the field(It will be corrected later) first i did a check =IIf([rundate],IsNull(Date())) i get the result...

hi: i need to calculate months with days that past from the start of the months for now i'm using =DateDiff("m", [start date]'[end date]) now i have a problem let's say the "start date" was 20/10/2019 and the "end date" is 1/12/2019 so its one month and 11 days. Access referred the "20/10/2019"...

hi: i have a table for Student attendance. the table have "id" "month" "lastname" "firstname" Then i have the day fields "a"b"c"d"e" etc' what i need is to SUM all "yes" days fields for a month and show it as percentage for Each student. so in the student form I will put a text box named...

I searched the web but found nothing:banghead: My question is how do I change the DPI of an image from 96 to 300 My problem is that I want to print in black and white but in 72\96 DPI The print quality of the image is poor I have to do it through VBA because it is a running process of...

hi my db have to take a snapshot with windows 10 camera app the hotkey for that is "space" my problem that i don't want to bring the camera app to foreground the camera app is running in the background in full screen and access have a main form in maximize sendkeys " " does not work

hi: i build a db for register student automatically in first process it take a photo of the student so i'm using windows camera app with "sendkeys" but it stucks in the front i tried using "setforegroundwindow" like this code from here...

hi i have a db that take a snapshot to "c:\img" with extension of "jpg" there is only one file in the folder at a time the file saved each time with a different name how do i rename the file to "1.jpg"

hi: i build an union query from 6 tables For that matter we call them' tbl1,tbl2 etc' the have fields called "table name" "id" "first name" "last name" and some other fields now what i need is to add a field Called open record that well open the record in the form of the table i made a form...

hi: i have a table to store file path for images "lastname" "firstname" "city" "image" is there a way to auto insert the path of the image with name to the image field (c:\students images\John Doe california.gif) by the value from the table in regards eshai