Search results

uploading a gif image to show what is going on. As you can see the forms don't load on the Facility Info Tab, until I click on another tab and then click back on the Facility Info Tab

Unfortunately neither suggestion worked, i've had this happen in the past and had to end up deleteing and recreating all my forms, which I would rather not do again if possible....

if it were only that simple, everything is tied to a SQL backend. I've figured out the load time issue, but am stumped on why the forms aren't being displayed on the first tab

whatever caused the above issue is now causing the main form to take forever to load as well

For some reason, whenever I load my form with a tab control on it, the 1st tab that loads displays a blank form, when I click on any other tab and click back, it is displayed correctly. this just started happening for some reason after a compact and repair, any thoughts??

not sure, but changed the code back to the original and its working with all facilities, dash or not, gotta love DBs....

are you saying to type in the actual facility name after the = ? If so, that did bring up the record

DoCmd.OpenForm "FacilitySetupChecklist", , , "[Facility Name]= '" & Me![Facility Name] & "'"

I have this database that i've been work with for a few years now and it has grown into a beast thanks to help from several of you, but now I am running into an issue I haven't come across yet. Basically most of the database is filterable by a Facility Name, however today I encountered our...

Figured it out, forgot the dbo. eventhought I could have sworn I tried that first DBCC CHECKIDENT ('dbo.NewFacility', RESEED, 0);

When identifying the DB to use, use Tracker2; GO checkident('NewFacility.FacilityID', reseed, 0) GO I get the following Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'NewFacility.FacilityID'. Also Checkident is underlined and when I mouse over it, it states "could not find stored...

same thing, One thing I did forget to mention was I am still developing my database in access and this table was up to 41 records and then when I added a new row to test out a new form, it appeared to start over at 1 so wondering if the table somehow got corrupt

Tried it with single quotes, dbcc checkident ('NewFacility', reseed, 0) turns the table name red and get the same error. Tried it with double quotes,dbcc checkident ("NewFacility", reseed, 0) name doesn't change color, but still get the same error

Trying to run dbcc checkident (NewFacility, reseed, 0) and getting the following error, even though the table exists. Msg 2501, Level 16, State 45, Line 1 Cannot find a table or object with the name "NewFacility". Check the system catalog. Any thoughts??

Interesting, I'll have to mess with this and see if I can make it work as it appears to be a stand alone emailing tool server settings will be static as corporate uses exchange, I am already capturing the username so I will just need to prompt them for a password, Will work in some scenarios...

I am using the following code to generate emails from my Access database using a locally installed version of Outlook and it works without issues, but what would I need to change to be able to use Outlook 365 Web? Dim oOutlook As Object 'Outlook Dim oEmailItem As Object 'Email Set...

Actually upon further investigation, I guess I was opening the form as read only through the button click, DOH!!!!!

Nope, I just added it so there is no coding behind it, properties are Enabled Yes, Locked No I am using this box for a record search entry

I have an unbound text box on my form and for some reason I can click in it, but I can't type anything in it. If I switch to Design View and then back to Form View, I am then able to type in it. Any thoughts ??

Actually I used the Access Query builder to make the select statement, which worked, so I changed it to a Delete query, and then that is when I got the "Specify the table...." error I like to use the Access Query builder to create the query, then switch it to SQL view to see the actual code and...