New profile posts

Just having FUN! Making a DB for my local volunteer Fire Dept
mike60smart
mike60smart
It is very difficult to work out your process using your Relationship Diagram.
There are so many things wrong with the way you have structured your tables it would take some time to resolve.

What is the table 43 Fire Dept Delete used for?
F
Falcone203
Got lost in the woods here when putting it together. so I started IDing those tbls that were to be removed after I found my way out. That tbl, once I am sure, needs to go. It'a a duplicate that I messed up on.
I am here to solve your Access problems.
P
progetto software sas
is it possible to preview in a form an msg file (outlook) without being asked to open the file?
  • Like
Reactions: MajP
onur_can
onur_can
What do you mean by the msg file?
isladogs
isladogs
Questions like this should be done in the main forum to get a wider variety of opinions and so everyone can benefit
Hi @arnelgp
If you have time, I have posted a thread regarding "current active user". Please have a look.
Many thanks
Yesterday you provided the SQL
select id, invoice, dcount("1", "yourTableName", "ID <= " & [ID]) As Sequence, Status from yourTableName Order By id Asc;
I do not have an ID value. To simplify, assume a table of only invoice numbers with duplicates. How would I change your SQL to:
1) get a sequential number for each record
2) get a subset of sequential numbers by the invoice number
isladogs
isladogs
@BGIBERT
You should ask this question in the forum thread where you are more likely to get a quick answer
Good evening. Just joined today to find out answers for of my questions and hope I can help resolve some issues, though. Still a learner.
Hi CJ_London
could You please look at my thread, if you are not busy
Hi Everybody, I am new in this forum. I am learning VBA programming for Excel and Access. Would like to upgrade myself with the vast knowledge base available in this forum. In profession, I am a Mechanical / Piping Engineer, living in Thane, Maharashtra, India.
Regards,
Bibek.
I'm new to this forum and just joined today. I am an Access Developer for our local Food Shelf, but I am not a programmer and usually need help to use SQL. I taught myself the Access from online videos and chats. Hopefully I won't need to much additional help, but it's nice to know that this site is available. Thank you,
hello .. hope you are fine
i need to make a list box field in an access table its value depends on the value of another list box >>
Example a field2 is a list box its values appears depends on the value i chosen from field1 list box ,, so
i made a table for field1 values and another table for values of each value in field1
how could i control it
Back
Top Bottom