Search results

Thank you for the reply. I do not have the entire table deleted for it is used to store different bits of information the original linked table does not have (e.g. details of the events). The original linked table is simply used for the ID, the date, and the name of the event. I briefly read...

I am using a linked table from another database and a "local" table to compare data. The linked table always has the correct information so I am utilizing append and delete queries to ensure my local one stays up to date as well. These tables record upcoming community type events. The linked...

Multi-User & Cannot use Make-Table Query Good Afternoon~ After about a 3 week hiatus, I've decided to dive into my ACCESS project which caused much grief last time I was updating it. I have a database which will contain about 7k records at all times. This database will be used by about 12-20...

Panic Mode=True I've spent the past few weeks developing a database that uses some linked tables, append queries, delete queries and a MakeTable query. It all works splendid when little ol' me is using it, however it's time for it to go "live" and after reading all the benefits of splitting...

:: snoopy dance :: I figured it out! Hooray! This is certainly a fabulous Friday! :: cheers :: Thank you Thank you Thank you Thank you

Fabulous! This works for me when I hit "run" Question: How to incorporate this to work say when the welcome form is loaded? When I use the On Load: GetNTUser() I receive an error. Thank you Thank you Thank you

Thanks so much, again GHudson. I used the most recent code as a new module, however when I went to Run it, I received an error. Compile Error Sub or Function not defined. It points to this line: Public Function GetNTUser() As String then highlights: GetUserName strUserName, 100 Suggestions...

Thank you for your time and assistance, ghudson, however that does not seem to do as I require. I would like to be able to "grab", if you will, the UserName information the person used to log-onto her/his computer with. For instance, every morning after turning on my computer, I have to log-in...

More investigation revealed: This is from the Microsoft Support pages. I've tried using this, however the text box on my form always returns the "#Name?" error. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q148835 Option Explicit Type WKSTA_INFO_101...

My apologies Autoeng, in my first post I failed to spell out it was the fosusername() function I was using. ----------------------------------------------------------- Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long)...

It is my understanding and experience that CurrentUser() works with the Access UserID info. I wish to utilize the Network ID information. If I am mistaken, please educate me.

Win95 / Access97 Need Network User name ~ SOLVED~ Good afternoon~ After a few searches and copy/paste attempts, it seems I am unable to accomplish my new task: To obtain the network userID of the current user. The codes I used may not work very well with Windows95 and Access 97 (Yes, pity...

I've now had some time to study the weekday function as suggested, but am still not able to get the results I want. The report is based on a query which prompts the user to enter a date range and a manager code. Once the user enters the information, the report then groups the data by weeks to...

Afternoon~ I am using a database to compile a report which will group all dates in a weekly fashion. Unfortunately, my company recognizes Monday as the first day of the week, and not Sunday as ACCESS does. Therefore, when I sum the "weekly" totals, my figure is not correct. I reserached here...

Snoopy Dance Alexandre and RV It has been a bit since I posted, but I just wanted to let you both know that I was able to use the SQL to get the information I needed. You may see a few more questions form me in the near future as I now have the time to work on this project. Thank you both...

Alexandre and RV, thank you much for your time and replies. However, I seem to be doing something incorrectly. I wanted to be able to do this in my Query. Are these codes written for the eventual Report from this query? sidenote: Alexandre, I think you may be pleased with how much I've...

Good afternoon~ I have a table which contains information downloaded from an AS400 system. From this table I've created a query for the information I wish to use in a future report. One of the fields is called Canteen and contains varied entries. There are 3 Types of Canteens, AR SP and CH...

Please forgive me if this question is a no-brainer for all of you. My company still uses the good ol AS400 for storing a lot of information. Currently, we download some of this information into an ACCESS database for our manipulation pleasures. What I would like to do is then link the ACCESS...

I will try to make this as simple as possible. I have a report that runs off a query. The report has 2 grouping levels. For simplicity, the first grouping level is "Car or Truck". The second grouping level is "Chevy, Dodge, Ford etc." I have it all set up to calculate the total of all Cars or...

Thank you ever so much! Now I'm off to make it pretty :: cheers ::