Search results

@Micron; I have several records I want to import to Access, so it would be tremendous time consuming if I should edit data manually. I've read about the transfer Spreadsheet method - I'll dig into this tomorrow I guess.

Hi, Yes, import it back from Excel. I've first exported the table structure from Access to Excel, and then added info in the table in Excel. Now when finally ready I want the info imported into Access - without success. I'm in Access when getting the error message. I try different methods in...

Hi, I'm about to import a spreadsheet from Excel into Access. The table in Access is empty (no records) due to that I've deleted all records. The table had some records previously. I've exported the table structure, filled it with info and then tried to import it back to Excel. Now I get a...

Hi, thanks once more for your input. I appreciate it! 🙏 🙏

Thanks for all your feedback and sharing! 🙏 🙏 I'll consider your advices.

Thanks for all feedback! 🙏 🙏 My idea is not to split the database until I think I'm ready to do so (but I know I'll face new wishes from the users) and all users will have their own copy of the FE version. The only thought left I've is what about if I have one BE version on my machine as well...

Hi there, I need some advice. What is the best way to work on a daily base with Access and how should I set up the structure? My idea is as follows: Split the database with all tables (amount of data is not so big) in one back-end file and then have two front-end versions. One non-editable...

Hi, @isladogs; I'll follow your link and see if that helps, but it's the access to the VBA files it's missing... @arnelgp; So you always do updates in the un-split one? And then you split it all over again? Do you then also need to swap the back-end version even if you don't have done any...

Hi, No, the font-end is my version, which means full editable. And it's this fron-end I'm working with.

Hi, Access can be patience testing I must say. :rolleyes: Especially when I can't think of something that I've done differently compared to before. When I'm running a front end I now suddenly get a message that the VBA file could not be accessed. The network connection may have been...

Thanks for your response! I corrected my line according to your first input, but still the subform isn't updated. So, then I started all over again. I created a new blank form, added the subfrm - Ok, the info is there. Then I added the combobox and got the After_Update event to work as well...

Once more; 🙏 🙏

Hi, I've a subform which is based on a query. The query is based on different tables, and one field is [Initials]. The query and the subform is working perfect when I run it "stand alone". Now, I want to put this subform in a new form, a mainform, which contains a combobox. I use this control to...

Finally! Thanks a lot! 🙏👍You're my heroes as well as all healthcare professionals in these covid-19 times.

Thanks for your support. I'll check out this later tonight and post a reply 🙏 🙏

Ok. I've tried to change without any success... I'll reframe the whole issue. If you where about to assign, using SQL, a field the actual date of today and another field a concatenated text string as strMsg above. How would you write this in VBA?

This is a screenshot: 1. I just want to include the date of today 2. Now I get an error message "Syntax Error". An operator is missing ??

Hi, Now, The error message says: (It has been different messages during my journey ...) Error 3061. Too few parameters . 1 was expected. Thank you 🙏🙏 for your attention and support!

Hi, I use the query tool to create SQL strings that I then add in a VBA module. I've created the one below, and I get different errors. Does anyone see some odd things? I've tried out different soultions now for an hour.... The mistake is somewhere in the two last lines, that for sure :rolleyes...

Hi, I've a combobox, linked/bounded to a table, where I choose a town. I would like to have the possibility to, when needed, add a new town, that doesn't exist in the table and then next time this new town should be present in the table of choice. This must be possible to do with some nive VBA...