Search results

Thanks...I'll likely be back in touch 🤪 got to try and put the contents of the textbox into a table now

Perfect!! Thank you very much!! Works great, much better solution for me, thanks again

I get an error 424: Object required. Ideally I'd also like to pull out the field title from the PDF so in the access textbox it would read First Name: Joe Bloggs

'theDBguy's PDF Form Fields Demo 'accessmvp.com/thedbguy '9/24/2017 'v1.0 'Demonstrates how to get a list of form field names from a fillable PDF form. '- 'Copyright Notice 'This demo was originally created by theDBguy@gmail.com. 'You are free to use any code from this demo, provided you also...

Thanks DBguy, this is getting in the right direction, however it copies the fillable name and not the data. EG: Question: Date of Birth: The fillable box is called DOB. The database form returns the value DOB and not the actually date in the fillable field. If I can copy the actual data...

It looks like that is just exporting data to PDF, am happy making the fillable PDF, just don't know where to start with VBA to import the data back into access table

arnelgp a fillable PDF would work and be much cleaner, have you any links or examples on how to go about this? I really don't have a clue...sorry! I have PDF editor etc.. so can make the PDF, just not sure what code I'd need to import the data into my table

I've been using the excel workbook until now, but it requires the new employee to have access to excel then us saving the workbook in a specific location when we get it back. It has worked to be fair, just wanted to try and make it a bit more user friendly for the person returning the information

Looks at Uncle_Gizmo's post on it. It is straight forward but I need it automated as much as possible as I'm not always the one importing the data, need a clean solution, I'm thinking email is the easiest way as I don't have a webpage to use for data collection

I've been looking into that a bit, I think the person sending the data back needs a google account to do so, also I'd need a google account (which isn't the end of the world). I note in Access 2007 and 2010 there was a Collect Data Group function.....this seemed more suited to what I was after...

This works now, but it is quite a crude way to import data (a little clunky copying and pasting). Does anyone have a better solution where by I can send a link to a form that someone can open with their phone, enter the details and then me import the details into a table? It is basically for...

Thanks arnelgp..... 🤪 couldn't see the wood from the trees late last night

Hi All, I am trying to create a simple way that people can enter data into an email (in a perfect world some type of online form that I can send out a link to) then with this data import it into an access table. I've managed to get as far as a text box with command button that puts the field...

Thanks very much Pat, I'm flat out today but will def spend some time on it in the next few days. HNY everyone!

Not sure what I was looking for but didn't see anything out of the ordinary.....never knew there were hidden tables!

To be honest I didn't understand it

I'm assuming you mean something like the attached? If so how do I then chose an item on the form from the equipment list that then stores the compID in the refit table?

Any chance to show me a sample DB with a simple explanation of this, struggling to get past this

Expert advice is easy to follow if your an expert, I don't follow the below This is a crutch for absolute beginners. Once you know enough to create a query, you don't need the "feature" and you certainly don't need it for forms or reports. Users never look at tables or queries, only you do...

Agreed but just don't have the time to start from scratch, sorry!