Search results

Hello. This might be a ridiculous question, but I'll ask it anyway. Is it possible to create a drop down for time (with 15 minute intervals) that allows the user to choose from an AM/PM setup, but after choosing the value Access would translate that into military time in the field? Thanks in...

Hello. I need to create a total for a field in a query. Simple query. 1 table. But the problem (for me anyway) is that the field that I'm referring to is in the query twice. Once as a group by and another time as a count (to count the total times a value is in that field of the table). So when I...

Hello. Can someone help me with a simple IIF statement with 2 conditions? I just have an unbound text box with the following in its control source: =IIf([ispaid]=Yes And [Balance]>0,"NOT PAID IN FULL!","") All I want is for NOT PAID IN FULL! to populate the text box if the isPaid check box is...

Hello. Is there's a way to set up a cell (used as a signature box) in Access to take in a secret code (per user) that gets matched up with their corresponding signature (initials)? Example, Mike Smith can't just enter MS. He would enter his code 5XR4T when he does MS will appear in the signature...

Hello. I have a database that I'm working on. I've created a JOB table that is the centerpoint of the various other tables related to the different processes. The idea is that each of the other tables will be connected to the job by the jobID field (primary key of the JOB table). There's a...

Hello. I have been trying to figure this out, but no matter how much I research it or how many attempts I make, I can't figure it out. What I'm trying to do is work with 2 tables. The first table is very similar to the other 2 tables, that only difference would be that it includes the customer...