Recent content by RoyinForest

I have specified a title for the database and it displays fine. However ACCESS is also showing the license owners account name to the right of the title. This is unprofessional in appearance and (in this case) an infringement on my privacy since the account is in MY name not the business name...

Here I am looking for help again. I'm re-writing an existing app (to go from access 2003 to access 2016 on Windows 10). Because I'm doing the work on my computer it means I'm using MY licensed version of Access 2016 for development before I ship the code to his...

Problem resolved. User error. They were checking off the box to "MATCH CASE". Embarassing but at least easy to fix. Confirms once again to never listen to what an end user says, WATCH THEM DO IT!

This database was created using Access 2003 (I know, no longer supported, etc). If I upgrade Access to latest (2016?) would I need to re-work the database to use it or would I be able to just open it with the later code?

It is the drop down I get when I put the cursor in a text box and hit CTRL-F to do the find. The field is type-text with a length of 255. If I put the house number part of the address in the "Find What" box, no results are returned. If I just put in the street namee, I get both house number and...

Unfortunately that is the case. The only difference I can see is that I was not able to go through another Windows 10 upgrade wih the sample database I made. Still seems weird that a search on a character field gets blocked by numbers at the start. But that's access - great when it's working...

Unfortunately, I can't post the database as it is a company asset. And when I tried to make a subset everything works correctly. (but I don't have another Windows 8.1 system to upgrade with it.)

I recently did an O/S upgrade from Windows 8.1 to Windows 10. Thought everything went well but then I tried MS Access and found a problem with the Find and Replace function in my form. When I search in an address field I find that if the data in the record begins with a Number (eg 123...

I don't see any place to click on "thumbs up" or mark this as solved. Guess my rookie status is showing.

Unfortunately yes I did run a compact and repair. It reduced to size to about 5.5 Mb. Zipping it cut the size to about 2.4 MB. The max size is 2 Mb so I still can't email it to you. I did put it into my dropbox and sent you the link so you should be able to get if from www.dropbox.com using the...

I couldn't even connect to this website earlier today until I switched my DNS server away from my ISP. (tried 3 PC's). Anyway, I'm obviously on now. the picture was the error message and I retyped the error in text in my reply last night. The zip file is about 2.5 MB and shows on my SENT mail...

Hi Jon I will post a zip file in the forum but since it is for a family run business I'd appreciate it not going public. For this purpose I have deleted the data from the "field invoice 2" table ( the main table for all data entry ) and then added two test records. The...

I'm not trying to invoke Excel or to have it run a formula or anything. I just need to create a string of actual values for the fields in the query. Once I output the string it is all integers and text. (problem is I have blanks for some fields instead of integers)

I've written a complete ( I hope ) description of the problem and am attaching a document with screen captures. Basically I have a form with a subform that works right to let me enter data. It does not let me extract some of the data using a query.2448 "You can't assign a value to this object"

I don't know much more than I've already said about FE / BE etc. The database was "split" by the "Make MDE" button so that the tables, and code are protected from user changes. I originally thought it also meant that the MDE file had to have a path to the MDB file in order to save data, but that...