Search results

try that it worked for me https://support.office.com/en-us/article/access-reports-that-databases-are-in-an-inconsistent-state-%EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d

Because of all the misunderstanding here (my problem with the wording) I feel I have to explain what I did My system was not responsible for student attendance This was done by another system. at one point they asked me to put it in my system My approach was to create three tables...

I really appreciate you friends It is a huge database used by 10 end users Believe me, it's all built according to the rules you wrote here Here, in this case, it is a database that only deals with the presence of students on only one computer And the tables are linked. I couldn't build it from...

ok thanks you all i solve it in the quiry i put this code countattendant: Sum([A1]+[B2]+[C3]+[D4]+[E5]+[A2]+[B2]+[C2]+[D2]+[E2]+[A3]+[B3]+[C3]+[D3]+[E3] +[A4]+[B4]+[C4]+[D4]+[E4]) that code give me a new colman that are showing the number of "true" for the id the reason of those field name...

my code countattendant: count(iif([attendance]![yes_no]=yes,1,null)) now can warp all my yes/no fields for a record instead of the"[attendance]" in the code

namlian my design is good i know what i'm doing it's not my first db my Q' is there any method like in Excel to warp cells [A1 to H1] and get the result i know i can use "count(iif statement)"

wow Uncle Gizmo, Micron sorry to be rude but i know exactly what i'm doing and my table structure are perfect the "month" field is "date" (1.12.2019) the "a,b,c,d,e" is a day of a weak did you ask yourself in which language is my db? let me tell you is not in english and its using a different...

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...

CSV is the Structure of a file. what is the program that create the file for example if its excel The file can be open in Excel and is stuck. try closing the program

Funny but I just got a phone that they want the pictures in color so it solves all my problems and they are ready to invest in a quality printer:D

I've already set all these options in the printer driver And it didn't help I'm trying something new now. Export the document as PDF with 300 DPI Then print the document

create a new empty db then import all from the old db compile and run

Not exactly true. Because I want to add DPI for printing And not for the image itself (resolution quality) All printers add the missing points themselves but it's black and white The image comes out poor because you can add either black or white Once I change the DPI the image quality will not...

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...

that well bring the camera app to foreground ammm not solved

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

It worked fine sendkeys "%{TAB}"

ya sorry i ment "ptrsafe" for the declaration on x64 system maybe "sendkeys" alt+tab well work just how to hold the Alt key?

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...