Search results

Thanks Khalid_Afridi, this apparently does need to be a little more complex than this though. Trying this, it appears you still need a way to either requery or refresh the textbox (if someone different then uses it without reopening), also it only seems to work if the frm_SelectUser form stays...

Much simpler approach, that is for sure - thanks! Still not sure why the other wasn't working after cycling through, but this will definitely work instead. So much to learn...don't even know where to start!!!

Didn't work on the Got Focus, works once with the default setting, but if for some reason you cycle through the forms again without re-selecting a name in the combo box, it loses it.

Yes - I want to have a text field at the top of the forms showing the name of the person currently "logged in". It works to show the name on the top of the 2nd form, but if you then go back to the 1st form, and then back to the 2nd form again, it seems to cancel it out rather than retaining it...

I am trying to be able to have the user log into the database by selecting there name from the list of Users, then saving the user name as a TempVar, and then showing this field as a text field on other forms. I don't want the user to need to select there name each time they end up on the main...

Thanks for the quick reply, the later is what I am looking for as I wouldn't want to constantly have to recreate all of the other items about the orders not being pulled down.

I need to track orders and shipments from two different data sources, along with other items about the orders. Basically my thinking here is a main table for the tracking, appending the new orders to it, then mapping the appropriate shipments to it. Currently I have a query pull the orders...

3/24/2000 displays as 35147

USA mm/dd/yyyy

I searched and found other issues with importing Dates, but none addressed the issue I am having. I am importing an Excel 2007 worksheet into Access 2007 via Access - External Data - Excel My spreadsheet, Access, and Regional setting are all for US. The date in the spreadsheet is in...

That is correct, it can only be done (viewed) in SQL View.

Thanks on both counts. That did the trick.

In my current system I have absolutely no control over two other sources which I need to map together based on items not being an exact match, but I do know the pattern of the differences (namely one system for what ever reason sometimes adds an "S" prefix to the front of a character string...

WOW, thanks a ton...a lot more I obviously need to learn here. I will definitely be checking this all out in more detail!!!

Must admit that I am pretty new to this, why would this be an issue? As stated in my other reply - the maintenance is definitely less in keeping up one location instead of many and having to redistribute for when any changes are done. Maybe in this case it doesn't matter as much since really...

Thanks I will look further into this.

The app itself isn't local, everyone who uses it gets to if from a shortcut on their local machines. Really wouldn't want to have to distribute a new copy any time any changes are made to it, nor would I want to have to make changes to two versions of the same tool. Thanks for the idea -...

I have an access database front end to a SQL Server back end, written in Access 2003, stored on a shared drive. Some people have upgraded to Access 2007. Each time the database is opened in a different version of Access from the last time, the tables need to be re-linked or the person gets...

Thanks, I will try this. And I agree it is not the way to create a database, unfortunately I am a small cog in a bigger wheel and am just trying to connect to the data they already have in my own Access Front End to make it work smarter for me at least.

Thanks for the quick reply. Basically I think what I am trying to do is create a form with a subform. We have a table with data in column 01, 02, 03, 04 --- 14 and an ID column. The ID column references back to another table which identifies what the data in each column represents. So If...