New profile posts

What's new Featured content New posts New profile posts Latest activity
thebigman
Hi there are you still using access ? I have come across your code to move a record from 1 table to another and struggling to get it to work. Do i make the new table with the same fields as existing one? Also is it just the new table I change in your code? Thanks very much for any help.
mike60smart
Hi

If you need help with your database and you use Skype then i am willing to help.

My Skypename is:- Live:mike.s23

Regards

Mike
R
Does anyone out there have a sample of the VB code to pull data from an access 2016 form and insert that data into an existing PDF form?\

I had been banging my head for weeks over this, i think its possible but all the code i had found doesnt work. I think as i have learned i need to export that data to an xfdf file from within access is that correct?

any help is greatly appreciated.
  • Like
Reactions: Johnson56565
theDBguy
theDBguy
Did you already look at my PDF demos on my website? You don't have to use XFDF if you have Acrobat or another PDF creator tool available.
A
Hi Mike,
I hope you are enjoying a happy life, may God bless you and keep you safe and sound, Amin. But, it seems very strange you are still alive because, you were on Skype.

Eagerly waiting for your reply, please.
P
Thank you MajP for your Date Picker selection. I'm a real novice a Access VBA but learning a bit more every day, your instructions are perfect and they got me out of a hole. Much appreciated.(y)
I
Thank you for helping me most of the time. I posted a question, may be if you have time to help out in this post.

Solved - Combo list item wont show up immediately in a navigation form

I have navigation form with different tabs. One of tab is connected to a form “FormA” and this form has a combobox with limit to list items. This combobox list items are sourced from a table. But infront of this combox is button to pop up a form “AddTypeForm”, by this user can add more items...
www.access-programmers.co.uk
I
Hi @arnelgp , thank you for helping me most of the times. I posted question, may be if you have time to help me out there..

Solved - Combo list item wont show up immediately in a navigation form

I have navigation form with different tabs. One of tab is connected to a form “FormA” and this form has a combobox with limit to list items. This combobox list items are sourced from a table. But infront of this combox is button to pop up a form “AddTypeForm”, by this user can add more items...
www.access-programmers.co.uk
H
hiii ....can you help me to filter listbox by command button then search by textbox
listbox datasource based on query and used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" on testname
but
button1 on click List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
button2 on click List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
when i click button 1 .....listbox nolonger filtered by text search box
H
hiii ....can you help me to filter listbox by command button then search by textbox
listbox datasource based on query and used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" on testname
but
button1 on click List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
button2 on click List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
when i click button 1 .....listbox nolonger filtered by text search box
H
can i filter listbox by both command button and search textbox
View previous comments…
H
haitham Elareny
listbox datasource based on query and used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" on testname
but
button1 on click List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
button2 on click List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
when i click button 1 .....listbox nolonger filtered by text search box
i want to filter listbox by command button then search in listbox by textsearch
H
haitham Elareny
listbox rowsource based on query in which used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" in testname field
on load it filters listbox
Private Sub Command2_Click()
List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
End Sub

Private Sub Command3_Click()
List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
End Sub

Private Sub txtsearch_Change()
Me.List0.Requery
End Sub
H
haitham Elareny
i wish to help me since i was tried more
G
Welcome. Looking forward to your contributions. Your first post was spot on.
A
alphonseg
Thank you. I'm hoping this forum will be more interesting than the MS forums.
H
hi arnelgp

still I need your help in my post

ranking with many condition

good day for all please help in following In company we have a lot of employee Company make summer resort to many place Like place 1 ,place 2, place 3… And we want to get ranking for each employee depend on many rules If many employee select place1 and group1 I want ranking employees...
www.access-programmers.co.uk

please check ranking serial

is not correct

thanks for you help!
View previous comments…
arnelgp
arnelgp
I already given you two examples.
you ask other people in the forum.
I already done my part.
  • Like
Reactions: hatmak
H
hatmak
thank u for reply
when I filter data
rank not change as filter
look like
1
2
4

number 4 should be 3

do u understand me
thank u again
H
hatmak
please try to change filter and see ranking
Z
Dear Mr Sonu,
Regarding your post "acCmdInsertHyperlink does not allow to set a default start folder" in which Code 1 and Code 2, to Open the File in Specific folder.
May I know that this Issue resolved? As I am also facing the same issue with my DB in Access.
Kindly guide me.
Regards
Zubair Mughal
The_Doc_Man
@jcsuarez - your question via the Profile Post method requires an answer that is too long. I will create a conversation to answer what I need to answer.
Back
Top Bottom