I have a database that appends, amongst other things, the Date() function to a table via an SQL statement. On PC this work beatifully but in one of the areas that need to use this isn't working correctly. Instead of the date appending as dd/mm/ccyy (Australian format) it's somehow going in as...
I have done this many times...however I use straight Access code rather than recordsets...on the enter button on a login form I use dlookup to check whether the userid (or name) and password are in the UserTable. (dlookup only works in access. The isnothing function determins if the lookup is...
Thanks for the answers guys.
I have read that a saved query will run slightly faster than an SQL statement, although in this particular case it won't make much difference I would think.
Two parts to me question...
One
I have a database that will potentially have 50-60 users. It will have a frontend located on each PC. Each user enters data into a form and when they hit enter it adds that data to the backend on the server.
To do this "adding" which is the quickest...
I am creating a column graph to show number of transactions per week/month/quarter over a period. There are times however when there are no transactions in a week/month/quarter, and currently my graph doesn't show these zeroes (because my query doesn't show it). Do I need to change my query or...
I am creating a column graph to show number of transactions per week/month/quarter over a period. There are times however when there are no transactions in a week/month/quarter, and currently my graph doesn't show these zeroes (because my query doesn't show it). Do I need to change my query or...
I have an access database running on a WIN NT server that previously ran an a netware server with no problems.
Now 3-4 times per week the database drops out but the network in general doesn't go down.
I know its probably more a problem with NT than Access itself but any info will be a great help.
To run a function from a module when you click a command button, you can use the code Call FunctionName()
This is the same as using a macro and the RunCode action.
I have a form with a timer that reminds users every half an hour to enter their data.
At the moment a msgbox comes up which they click OK. (when access is minimised the msgbox comes up flashing on the task bar)
When they click OK I would like to maximise Access, to save them having to then...
I want to set a graph's row source on opening a report based on a form. This code won't work:
Me.OLEUnbound0.RowSource = "QueryName"
I know I need some special code for manipultaing an OLE object (but I don't know what it is)
How do I do it?
I want to set a graph's row source on opening a report based on a form. This code won't work:
Me.OLEUnbound0.RowSource = "QueryName"
I know I need some special code for manipultaing an OLE object (but I don't know what it is)
How do I do it?
Unfortunately I have no actual external connections. It's an all inclusive database which somehow is losing it's network connection. Could be timing out somehow?
I have an Access97 database being used by 5 users over a WINNT network. Each user has the database open all day. About 1 or 2 times a week the database loses its connection to the server and some data is lost. The network itself however does not go down as no other networked apps go down. It...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.