Search results

luckily it was already sitting in the backend..just not selected when I linked the tables in front end as it was a copy of a table. All good.

figured it out. I imported to the front end and used the link to command choice. Way too easy. :D

Using Access 2016 Split db. did not select 1 of the tables when linking I now need to get that table into the be which is located on a backup copy of db Can I just import to the backend? And then, will I have to install new front end copy to everyone? or can I find in front end and link from...

So this is a DUH moment. My table is populating. When I run the query, there are 750 rows. the first 730 rows are blank because I didn't link with anything worthwhile, LOL! so it just gave me the autonumbers to blank data. The bottom 20 are being filled in with my data. Even with the lookup...

that doesn't make sense about the lookup field. I have numerous db's with drop downs with no issues.

yes it does have a lookup table.... I will definitely read up on this. Thanks

I will work on that today. The db has been in use for yrs so lot's of data to be stripped if I went that route. I'm adding this new subform. Thanks for all the help.

I'm thinking not...hippa violation. Wish I could...

Ok. so I removed the fields in table and qry and form. Still not populate. Changed control source of subform to just the table. nada. What in the world? I hate that this is besting me.

have to put my Access hat on this week. I created a table (tblsvctimes) I created a query(qrysvctimes) using table and created 2 fields using calculations to generate hrs and minutes I use this query in a subform linked to mainform by svcticketID. I populate the subform in couple different...

That's funny. I just added this form to my favs from a previous post I found. Thanks.

=[Forms]![EpisodeTable subform]![EpisodeID#] My formula to populate a field in a subform from another subform. Keep getting the #NAME? error on the field. Do I need to also reference the main form in this control? I just can't think anymore, and I've done this numerous times in the past...

It was missing a general declaration on that specific form.

I have a form upon opening a MSAccess 2016 db. It grabs the UserID. Option Compare Database Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name...

Is it possible to get into an mdb that has security permissions and no one is able to make you a user of a group that has those permissions?

I did rename all the tables when I put the new table out there with the new fields. However, the relationships were looking for the 2-28-17 table so a lot of the forms were looking for that table instead of the episodetable. I've since restored a good version with the old table layout and...

wow..that will be monumental...so many relationships with this table

I've copied a table and added new fields I appended old records from old table without new fields. renamed old table and used the existing table name for the updated table. The original table was called episode table and I kept that name with the new fields added so would not have to change...

created a client form and placed in the details section of a form The form footer contains a tabbed section of subforms to go along with said client form. when form in view mode and all the fields are not populated in the client details section, it will only show those fields which are...

comes over to the table too....