Search results

Downstairs for dancing !!!! June7 thankyou so much. Brilliant. I had forgotten about that. (Just returning to Access after a few years off)

I would like my User to be able to use the Carriage Return as normal (ie without having to press [Ctrl]. at present, using the carriage return "tabs" to the next field. Once a User starts to type within the field (onGotFocus) they are effectively "trapped" within it and have to "Mouse" or "Tab"...

Hi Minty (long time no see) And once again you are my Angel of Sweet Tray !! Mark as complete. I trust you are well, I was just revisiting our old posts (2016) Thanks for your solution.

Hi Ranman I altered my code to this (as suggested) CountNumber = DCount("UniqCONCAT", "tblDataTable", "UniqCONCAT =" & KONKAT) However I get a SYNTAX error (missing operator) in query expression. Thank you for trying to help though. Am I going about this the right way? I just want to check if...

I am looking to create a check to see if a concatenated field is already in a table. It works if my criteria is text but it doesn't work when I'm using a Dim concatenation. Here is my Code: Private Sub Command10_Click() Me.UniqCONCAT = (Me.CQRWeekNumber) & (Me.UserNametxt) & (Me.CQRSite) Dim...

Hi all I have an image attachment to my welcome form. The image is the users image. When I rest my mouse over the image I get the prompt: "Double-click to view or add attachments" I would like to remove this? I have tried to change the Data enabled/Locked for the image Restricted the data for...

Thanks Arne. I researched myself and found the answer to use the attachment approach. Works a treat. Thanks

Is it possible to have an image for each person in my database and for that to be shown on a form. ie. so when that person opens the database their image is shown. If you could point me in the right direction that would be great.

Thank you for your solutions. I used CJ's solution.

Im trying to insert a user name into a table on opening a Welcome Form. The error is within the DoCmd.runsql. and on opening the form it is asking for GUN? Could anybody please advise? Me.GetUserNametxt = Environ("username") Dim GUN As String GUN = Me.GetUserNametxt DoCmd.RunSQL "INSERT...

https://www.youtube.com/watch?v=pJL1CCfvf7s Dealt with !!

Hi Arnelgp I get #Name? when I use =environ("username") ?

I've got my name in the top right hand corner but if I use: = CurrentUser() It returns Admin I'm looking to get my name

I am working on a network where the user of Access is logged in. I want to extract this user into a table. I would then be able to relate this to a table of permissions in the database. How would I go about this? Thanks for your time in advance

I ended up creating a union query for each field then appending it to Table2 This involved unionising 1 to 40 fields, then 41 to 80, 81 to 120 and 121 to 160. Then Union these Union queries. 40 Unions seemed to be the Max amount. What a ball ache !!!

I could do with creating a looping Insert into query where Field1 increments to a finite number (255) or it goes to the next field and/or loops to next INSERT INTO Table2 ( Name ) SELECT Field1 FROM Table1

My Excel Data is the selecting and copying of column headers: "ColumnTitle" "ColumnFirstName" "ColumnSurname"etc If I select a new row in my Access Table1 and paste my data into it I will get one row containing all of my column headers. i.e. I will get "ColumnTitle" in FieldOne...

I want to select my (variable) columns from my Excel file and be able to transform paste into an Access table. The easiest way would be to transform paste in Excel but for functionality I do not want to do this. What I would like to do is to paste into a row table (that contains several...

I am just learning to query my data in an SQL Database. I am totally familiar with the graphic interface of Access to create queries but need your advice. I can end up creating several queries within queries to get my result. How do I look to do this in SQL? Do I build it in one complex query...

Fixed. I have simply put a Filter "" on opening the frmHolding Yay !!!!!