Search results

OK but how can i use this code into query?

Dear all, First i would like to thanks for your help. But, i need to have the age result as a number like the following example: Because the age accuracy it's very critical issue for my database because it concerns a pediatrician software which using child development graphs direct from the...

Hi all, Dear friends i nees help on haw can calculate the age into query expression. I need the age as follow: 18 years, 11 months and 14 days..! Is it possible to have this result into query? Thanks in advance

thank you very much, working fine. thanks

Hello my friends, I have the following problem: Attached you can find my example database which includes one main form (MAIN) in which there is another one subform (Subform). The subform (with name: Subform) takes data from one table and includes as you will see, the subData subform in...

Ηι, How can i do this "theDBguy" ? Could you please give me some details? Thanks again

Thanks, i will make some testings

Hi, Cowboy_BeBa, This time i'm working on something very similar and i found very helpful the following idea (which is tested and working fine)¨ 1. Using the smart phone (any) i found one application which can creates your own table fields (Id, Barcarole, qty etc) and using the existing phone...

Hello to all, Because this issue is something I haven't addressed, I would like to ask if an access form can have RecordSource directly from an external SQL file. For your best understanding on what i'm trying to do, please note know the following There is an SQL database on the same computer...

Good morning, Because I understand that the problem can be extremely complex or even rare, I want to make clear the following: 1. There is absolutely no problem with the way of the storing data as because its simply confirmation that the user has actually added the following: Patient Name -...

Good evening June7, Yes the database is split and each user has their own front end. Also, I comment to Microsoft and I'm waiting for their reply.. Thanks

Dear friends, (HELP . . SOS), The problem which is happening is totally paradoxical and I am really desperate because my database runs on a number of users and the problem is so paradox that I have reached the limits of despair. The problem is the following: The database is for doctors usage...

Morning, The report works without any error if run. The VBA code run using a command button on the report. So after your last post maybe the problem is because of that? You suggest to use a form and from there to call the procedures? If so, please explain how you thing is better to do that from...

Hi again, About the objectName:=Me.Name should be ok because if you check the first attached accent file which is the original file the report can be saved into a simple path. So about that I think we are OK. The report source it's from simple select query without any filtering with data. So...

100% something much crazy..!!!!! Have a look to the attached pic.

Now, after the below modifications, i'm getting the correct message that the new PDF file was created on the correct Path (C:\DatabaseFiles\Patients\1\Test.pdf) but the file isn't there and i get the attached error..! Any new ideas? Private Sub Command24_Click() Dim FileName As String...

Yes because i was tried to test it. If you cancel the comments again you get the relative error... (what a f.......day..!!)

Just for testing i make as comment the MkDir fldrPath line. After that i 'm getting the message that the PDF file was created into the specific folder....but......there is no pdf file into this folder..!!! Private Sub Command24_Click() Dim FileName As String, fldrPath As String, filePath As...

Today really i will be crazy..!!! Again problem with Path..! Already i have the main folder on C:\DatabaseFiles\Patients and i'm getting error..!! Please, is it possible to modify my last attached file? Private Sub Command24_Click() Dim FileName As String, fldrPath As String, filePath As...

Its crazy..!! I don't think so that the problem is something with Path because just know i test it with a simple Path like C:\Test\Patients and again i take the same error. Note, into Patients folder there is the sub-folder named 1 (customer no)