Search results

Can no one help with this? Apologies for the bump but I'm lost! Can anyone point me in a direction which would help?

Good afternoon. We're running an Access front end using SQL Server 2005. We have 2 seperate offices which use this application. The 2 office are linked wirelessly. One office (our call centre) uses it constantly, and this office has the SQL server and everyone is hard wired into the network...

Is this a frequent task? Is the time data always changing in the 2 fields within access? What you could do is create an update query which re-calculates that column. Then create a macro which runs that query and tell access to run that macro on startup. If you're frequently importing different...

Thanks for your insightful, educated and appreciated response...

Good Morning All, I am investigation some methods in creating a contacts system for our ever growing and very messy contacts list in outlook. As I'm experienced in access, I felt this would be my best method. Using forms and linking the contacts with many other tables and systems already in...

So I managed to fix it! I'm not sure where the issue primarily lies, however I deleted the "MS_Format" extended column property from SQL server which seemed to fix it for some instaces of the problem, however what trully fixed it was Exporting all my tables, forms, queries, reports etc to...

Well, adding the wildcard at the end basically means "Any Time" right? Time is being stored on the SQL server because it's a Datetime field. e.g. 01/10/2008 00:00:00 All the times are 00:00:00 and it's the same for older databases of mine. There's no formatting of the time in my access tables...

Sorry for bump, but this is causing serious issues for me.

An update on this: I've recently discovered that doing a filter for dd/mm/yyyy* works. If I omit the wildcard, it fails... epically! This would point it into the direction of some sort of error with storing time data. However this doesn't occur with my older projects which still makes it weird...

Hi Mailman, Thanks for all your help. Having 2 date fields may seem quite useless if they are in part referencing the same data. However they are 2 seperate columns in Access and in the SQL. The columns are not directly linked to each other in any way at all except for the data they actually...

Hi Mailman, or Namliam. :P Thanks for the reply. LCMonth and LCDate are seperate data, however for filtering and reporting purposes, I needed one column to have exact days in a month and one column to have the month that the date is in. If that makes sense... I've tried filtering in the table...

Thanks for the reply. I've attached 2 more images. The first one is the "design view" of the table and the settings in Access (And yes, it's via a MDB file, not ADP. Viewing the table on the SQL machine, there is a time of "00:00" on each date, however referencing my first post, this is the...

Hi Doc, Thanks for the reply. It's an ODBC connection from access to the SQL server. All the fields I'm having issues with are datetime data types. I attach an image of what I'm trying to do. After hitting enter, I get a Microsoft Error Report message. This also happens when trying to filter...

Good afternoon all, I'm struggling to find a solution to an issue I'm having when trying to right click and "filter for" on a FEW date columns in a linked table. This also happens in queries when i add a filter for the same fields. However when I filter on the same columns in a form, there...

Hi All, I posted this in the other post in this forum but it doesn't look like any has read it, and now it's becoming more of an issue to my customers. My appologies for the double post! I have a form with one subform. I'm using Lebaums mousehook.dll system to stop people from scrolling...

Now I have an issue with this if someone could help. I have a form with one subform. The mousehook.dll aproach is working and not allowing a user to scroll through records. And on the main form, it is allowing people to scroll through memo text boxes. However, on my subform, it's not allowing...

Ah yes. That would make perfect sense! Gotta hate mental problems that occur at the end of the shift! Thanks for that! Btw, when i right a routine, i always use the same variable to get the recordset and then close it all up at the end. Cheers.

Hello, What would i put "val" equal to if the query will always output 1 result? for example, if rst!DataColumn was "SerialNumber", and rst!Query was "qrySerialNo" sql = "SELECT " & rst!DataColumn & " FROM " & rst!Query Would be sql = "SELECT SerialNumber FROM qrySerialNo" and i would put...

You could use: If checkbox.visible Then This'll mean it will only do something if the checkbox is visible. The same things works with "enabled" and other things.

Afternoon, I'm setting up an email addy which clients can send data to. I want to write a bit of code that will take attachments off any unread emails, validate them, and send replies depending on the outcome (this needs to reply to the original email). Also, depending on the outcome i would...