Search results for query: *

We have a form which tracks information for certain tasks. Each day, different users record the information related to his or her own task in specific fields, and leave all other fields alone (there is no security in place to prevent it, they just don't). We're having an issue where each user...

When the code below runs, it highlights the first "Left" keyword and gives me a message saying it can't find the project or library. Any help is appreciated. Private Sub ChildID_AfterUpdate() Dim teststring As String Dim teststring2 As String Dim teststring3 As String...

I'm working in an Access Project to put criteria on an expression field to only show records where the left two characters are letters, not numbers. I've tried unsuccesfully using wildcards specific to each. Any help is appreciated!

Can anyone tell me how to set up compound unique indexes in A2K (as opposed to compound PK's)? I've heard there is a way but can't find information on it in Help or any books. Thanks!

Some months ago one database here began getting an error message when users tried to open it saying "Error accessing file. Network connection may have been lost." The network connection was fine, however. Users were completely unable to use the database, though it can be opened with the...

I'm using the make-table query below but I only want it to give me one record for each Student_ID (alias for dbo_corr.from_descr), where it has the maximum dbo_corr.entry_date value. I know I need a HAVING clause with a sub-select statement, but don't know the syntax to do this. Help! SELECT...

I changed a text field in a table to a memo field to allow as much space as needed to store text, however, now a query that was selecting that field only displays two characters (that I can't reproduce here). I use the query to do a mail merge, and now the mail merge displays things like ?', ?X...

I'm no VBA guru, but I'm trying to use the code below to change the appearance of a field to bold red if the condition is met. It changes the font color to red just fine, but does not bold it. Nor does it give me any kind of error. Can someone please tell me what I'm doing wrong? Private...

I know next to nothing about VBA, but can someone give me the syntax for making a msgbox pop up that displays the results of a SQL statement and has an "OK" button at the bottom? Thanks!

Hi... I have to compact our medium sized Acess 2K production database every morning because, even over the course of a single day, it can increase in size significantly. It's not uncommon to compact it from 80 or 90 megs down to 65 or 70. I've always wondered how it could increase in size so...

What is the syntax for an update query to convert something to upper case, i.e., convert br4579215 to BR4579215? I've tried Update To: >Left([fieldname],2), but it doesn't like the >, even though that is the correct symbol for upper case. Thanks!

I need a query to sort by a field called Child_Key, however, when I use "Order By" in the SQL below, it gives me a syntax error. I am using an alias on the table, and two aliases to create two copies of another table, but I don't see how that could be causing the problem because the...

I'm still very "wet behind the ears" when it comes to VBA, but could someone please tell me what's wrong with my code? This procedure is designed so that, if users attempt to open the database before 7:30 am, thus opening the switchboard, it will tell them they aren't allowed in, send...

I have "the mother of all Switch functions" (shown below) which, except for the last line is working perfectly. The last line has "Please email us immediately if you find any discrepancies", but the value that is being returned is "Plea0e e11ail u0 i11e1iatel305 if 305ou...

I could not open a table in my database and it gave me a message something to the effect of "Cannot open table; Too many nested transactions". What does this mean? Thanks!

How would I go about changing all the values in a field with alpha-numerics to remove the dashes (i.e. to change entries like BR-312-8212 to BR3128212)? Thanks!

I know this can't be that difficult, but I'm trying to put together syntax for the condition of a macro that fires if the current time is before 7:30 a.m. I know it would be something to the effect of &quot; if DatePart(hh;nn;ss, Now())< &quot; ... I hope this makes sense. Can anyone help...

I tried to compact/repair using the JetComp.exe feature but it failed and gave me a message &quot;Error Compacting Database.&quot; Although it may seem self-explanatory on the surface, I'm not sure I'm using the utility correctly (new to this feature). I selected my database on the Source...

I have 2 tables to join where year and mth are keys ... In both tables year is a 4 digit numeric. In one table mth is a 2 digit numeric, in the other it is a 2 character numeric (i.e. '07'). I have to maintain these formats, but how do I join on the mth fields ... ideas ??? My SQL is below...

Is there syntax to specify multiple &quot;where&quot; criteria in a Dlookup? I want it to display a value based on the combination of two other values in a table. Thanks!