Search results

Hi all, well i've got myself really confused.. and have a major headache.. I have 2 tables.. 1st is Cases and 2nd is NETANFImports i've already got an update query that works perfectly.. it updates fields in Cases from that of NETANFImports however.. the problem i'm having is, i cannot seem...

Lol.. i wont say how many time i've been trying things like that and even did intStore = DCount("[ID]", "[RWSlipsTable]", "[Active] =True AND Caseworker = " & Me.Text42) and still didnt work.. always seem to forget the simplist things like ' lol Thank you for making my night a lot better..

Hello Everyone, Hope everyone is having a better day than me.. as i just cannot get this to work... This is the problem, I have a table for tickets, and want a popup to show for the current user.. if i take out the & Me.Text42) it shows theres 90 Active tickets, but thats for all the...

Ok, not sure if this is even possible or where to even start.. I've got a form that has all the info for a client, eg.. Client First Name Client Last Name Client Hours Client WE/CS/EE Client Day And Times Client Phone Client Comments Begin Date & End Date (2 boxs) on there for date input...

ok, i found a way of bypassing.. i think.. Private Sub Form_Open(Cancel As Integer) Text524.Value = Environ("username") Me.Filter = "username =" & Me.Text524 Me.FilterOn = True End Sub except now i'm getting the value box with the username as the title, and if i type in a username then it...

ok, how do i explain this... what i really need is for when the form opens, it looks at todays date, then matches current user and then goes to that record for today, if no current user there, then will goto new record.. i know, sounds complicated, and probably is really easy, but my heads...

ok plog the way i currently have it, and so Reports can be created easily.. ID, Date, User1, User1 Sign-in, User1 Lunch, User1 Sign-in PM, User1 EOD, User2, User2 Sign-in, User2 Lunch, User2 Sign-in PM, User2 EOD, And So on.. so once you got 60+ you easily hit 255 Columns.. so basicly each...

Ok i'm having a few problems, as Access only allows 255 collumns and not sure how else to do this.. so hopefully someone else has already had this problem or even knows a way round it.. I've been tasked with building a sign-in form for staff to use daily.. with multiple fields.. Date...

ok, opening the Main form on its own works fine, but yes it does have code, none to make it hidden though. see the text included in first post.. We've been using this for awhile with no problems, i'm just trying to clean up things.. etc and also having it automaticly goto to the main menu...

because wanted them to see the notice that pops up, letting them know that they need to keep Outlook open due to being used in the DB.. Also if i do that excatly like you've shown it doesnt show the frmMenu at all..

Good Morning everyone.. Ok i've come accross a weird problem.. lol i have a countdown on 1 of my main startup forms, that checks to see if outlook is running if not then it'll auto start-it outlook, then when the counter gets to 0 it continues to load the main menu... Now if i have a...

i ended up using the following code.. Dim retval retval = Shell("G:\IT Information\Backups\Dont_Delete\Splashscreen", 1) 'Call module to hide access application close button HideAccessCloseButton Call fSetAccessWindow(0) DoCmd.Quit acQuitSaveAll the Splashscreen i had created using...

ok i added a splash screen that runs from an external app whilst Access is shutting down... it doesnt stop them from closing them both, but at least it warns them..

Ok the import went well I wanted to add the name of the person importing and the date, but that dont work.. so oh well.. Cases.[Imported By] = "Graham 7-23-2013" as for the message when closing, its when its packing/compressing that people seem to force kill, and any message box's by then have...

Ok, so i removed the Comments Section and re-made a new Comments section, changed the interperter section, and now it works fine.. so far.. however the main test will be tommorow morning, when i do the first main update from the online datebase that exports to excel to this access database...

Didn't think it'd be the comment section.. thought I'd turned off the interpreter party

Ok, tried again, making sure all fields were same types etc and still it does it.. So heres a copy, with the cases, import and query..

yep using your table it works fine, my table does have validation, could that be whats stoping it from running correctly

yep, i relized what was meant to happen about 10 mins after i left work yesterday.. However its still not doing what its meant to do.. I understand its meant to update the CopyOfCases with the data from NETANFImports, however when i run it, it comes up with the Value box for every cell...

ok i'm confused now.. i've got all my data that i want updated into the db in a table called NETANFImports, and the main DB Table called CopyOfCases however when i run the SQL Query it doesnt seem to update the Copy of Cases instead it replaces the NETANFImports with data from CopyOfCases...