Search results

I have been using Access for over 25 years. I want to transfer these skills to online database management. That is, I want to be able to put the same types of databases on the web and manage them just like I do with Access. I have tried different online courses but seem to hit a wall. Something...

I found the Unhide and Hide options. Thanks for all your help.:)

Thanks. I had to leave and I will take a look at it in the morning, CST.

Trying to help an associate. Had a quick look. In design view, you see all the query fields. In datasheet view you don't see all of them. How can you unhide a field in a query?

That was it. I did find a workaround. You had to change the Text Format of the field from Plain Text to Rich Text. I found it at this link. https://stackoverflow.com/questions/34279809/microsoft-access-2013-long-text-limiting-to-255 Thank you.

I have a linked back-end table that I am pulling data from with an append query. I am appending it to a local table. The query (Grouped) does not pull all the data from the back-end table. Here is what I have. Field Name: ActionsTaken Data Type: Long Text in both tables # of Words: 66 (only...

Good answer. Thanks for all your help.

I found a demo and downloaded it from the following: http://www.utteraccess.com/forum/index.php?showtopic=2039261 Do I just import all the objects into my DB and integrate it into the program? If so, will this affect any other objects in the program Thank you.

I need to capture signatures on forms in my databases and store them for future recall and print them as a report. I don't want to reuse a signature, but would like to store it as part of a record either in my back-end DB or another external linked DB. I don't want to create a file for a...

Yes, it is FE and BE. the BE is on a shared drive.

I have a lax management group that gives too many liberties to some of the users of one of my databases. I have gone over to work on them sometimes and found them renamed (how about Shaquille O'Neal?) and other such shenanigans. Another big problem, which I would like to address today is this...

You solved that. That was the answer.

That doesn't seem to work with a SQL link.

I have an Access database with SQL links. I have no control over the SQL. I was changing data in a table I wasn't using anymore by deleting all of it and using an append query to add the new data. I tried to append my own ID number to the AutoNumber field. It did not work. These ID numbers are...

Thanks, again. That is enough to get me where I need to go.

Thanks a great deal for your quick response. 1) The trackpad allows you to use your finger? 2) Is the trackpad a peripheral or part of the computer. 3) I assume you would put the cursor into the field where you want the signature, get the signature, and save it. What kind of field is it?

I have read a lot of information about capturing customer signatures in an Access database and am still confused. Here is what I need to do. I want to use a laptop computer and let a customer sign a form and store that in an Access database. I would probably pull the data out to a clean table...

Works like a charm. Thanks.

I found this article on this forum. The guy wanted to set the timer interval to close the database in 12 hours. He wanted the maximum number for the timer. The respondent suggested an alternative method. I would like to use this. Can you tell me how to create the procedure “intAppMinutes?”...

Each user has their own front-end.