Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 41
Search took 0.01 seconds.
Search: Posts Made By: cluendo
Forum: General 08-08-2012, 10:05 AM
Replies: 1
Views: 734
Posted By cluendo
Access --> Excel automate

Dear colleagues,

Is it possible to pass the Access report to excel (by clicking a button) and do the following things automatically: If record contains groups, then group by category in the excel...
Forum: Modules & VBA 07-31-2012, 02:59 AM
Replies: 0
Views: 582
Posted By cluendo
Quick question, calendar pop up

Hello. Here is a nice example of pupup calendar.

Everything works fine, except. When the text box is not bound to any table the date format is like this: d/mm/yyyy. I want to be like this...
Forum: Tables 07-26-2012, 10:14 AM
Replies: 6
Views: 1,818
Posted By cluendo
Re: Multi categories question

Thank you! I'm on the track now. I am almost done, but one thing is still not clear.
Images how it looks now:
Query: ...
Forum: Tables 07-26-2012, 06:16 AM
Replies: 6
Views: 1,818
Posted By cluendo
Re: Multi categories question

Anyone ? :( sorry for impatience.
Forum: Tables 07-25-2012, 03:49 PM
Replies: 6
Views: 1,818
Posted By cluendo
Re: Multi categories question

Thank you! But it's not completely clear to me, how I am going to select Which patient belongs to which doctor(s) ?

So far I have "Patients" table one to many relationship to table "Visits". I've...
Forum: Tables 07-25-2012, 10:16 AM
Replies: 6
Views: 1,818
Posted By cluendo
Multi categories question

Hello. I have one question for you guys. I am not sure how approach the problem I have so I hope someone will be able to help me.

Here it is:
I have one table for "Patients" (ID, Name, bla, bla,...
Forum: Modules & VBA 07-11-2012, 04:28 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Ok guys, somehow I figure it out myself. I will post my code today, to check if it is efficient and do not have logical problems (although it is working) :)

vbaInet - big thanx for you, but don't...
Forum: Modules & VBA 07-10-2012, 09:07 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Thank you. I'm working on it as well.
I never thought that notinlist event is such a pain. :) or it's just me.
Forum: Modules & VBA 07-10-2012, 08:51 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Here you go:

http://www.mediafire.com/?54g7m5fcewgu1bo

I made everything again, but still get same error.
Check it if you have little time!
Thank you!
Forum: Modules & VBA 07-10-2012, 08:33 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Ok. I cannot save it as older version because I use "some new features" lol.

But I'm working a new one, fresh one :) It will be here in 10 mins.
Forum: Modules & VBA 07-10-2012, 08:01 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

http://www.mediafire.com/?gzkz8saciywubx6

It 2010 access file. I do not know how to covert into older versions. Hope you will be able to open it.
Forum: Modules & VBA 07-10-2012, 07:15 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Ok I deleted my macro and made a code for save and close button:

Private Sub cmdSaveClose_Click()
On Error GoTo Err_Saveclose_Click

DoCmd.RunCommand acCmdSaveRecord

DoCmd.Close
...
Forum: Modules & VBA 07-10-2012, 07:01 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Now I get the usual error when using requery:
"Run-time error '2118'"
"You must save the current field before you run Requery action"

My save button have this macro:...
Forum: Modules & VBA 07-10-2012, 06:37 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Ok, but where to put the combo9.requery code?
And as I said before, when I save and close the AddNew form, the NotInList event occurs again.
Forum: Modules & VBA 07-10-2012, 06:06 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Ok, now my code looks like this:

rivate Sub Combo19_NotInList(NewData As String, Response As Integer)
On Error GoTo Err_Patient_ex_NotInList

Dim intAnswer As Integer
Dim Db As DAO.Database...
Forum: Modules & VBA 07-10-2012, 04:23 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Ok. I understood then.

So now which approach is better you think:
1. To open a new entry form when NotInList
or
2. To set focus text field "First Name" on the same form where combo box is ?
...
Forum: Modules & VBA 07-10-2012, 04:12 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Thank you for your help.

But is it possible to pass the FirstName and LastName(a new entry which is not in the list) to pass to the text fields "First Name" and "Last Name", so that I would not...
Forum: Modules & VBA 07-10-2012, 04:02 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

My ComboBox lists FirstName and LastName from the table "Patients".
RowSource looks like this:
Forum: Modules & VBA 07-10-2012, 03:46 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Thank you for the answer.
Yeah I know what you mean. But I couldn't think of another approach to this.

Do you have any ideas?
If not, at least can you give me a hint or something how to make my...
Forum: Modules & VBA 07-09-2012, 12:45 PM
Replies: 30
Views: 9,829
Posted By cluendo
Forum: Modules & VBA 07-09-2012, 11:20 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

Now I am wondering, maybe I don't event need to save the record straight away? Maybe it is better to pass the The values "First Name" and "Last Name" I've entered from the combobox to the Text Fields...
Forum: Modules & VBA 07-09-2012, 10:26 AM
Replies: 30
Views: 9,829
Posted By cluendo
Re: Combo Box, Not In List event, Access 2010

By the way can I use Queries instead of the table in the combo box RowSource?
Because I assume it would be easier to save the two values(Last name and first name) If I would make the query which...
Forum: Modules & VBA 07-09-2012, 10:05 AM
Replies: 30
Views: 9,829
Posted By cluendo
Combo Box, Not In List event, Access 2010

Hello colleagues,

I'm struggling with Combo Box and Not In List event. I want to be able to "add new record of First Name and Last Name if it is not in the list.
Here is the picture of how my...
Forum: General 01-29-2011, 05:47 AM
Replies: 5
Views: 881
Posted By cluendo
Re: Trim with space two values

Im Sorry, everything works fine! Thank YOU!!!!

I forgot to change Right to Mid

Me.LastName = Left(OpenArgs, InStr(OpenArgs, " ") - 1)
Me.FirstName = Mid(OpenArgs, InStr(OpenArgs, " ") + 1)
Forum: General 01-29-2011, 05:26 AM
Replies: 5
Views: 881
Posted By cluendo
Re: Trim with space two values

Ok I managed to fix that:

code now:

Me.LastName = Left(OpenArgs, InStr(OpenArgs, " ") - 1)
Me.FirstName = Right(OpenArgs, InStr(OpenArgs, " ") + 1)

No error message, but Now Last...
Showing results 1 to 25 of 41

 
Forum Jump



All times are GMT -8. The time now is 06:59 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World