Search results

Eh? Ok... If I am understanding you correctly... I do something similar... I create the following: --------------------- tbl_Projects --------------------- prj_ID [Autonumber - Primary Key] prj_Name prj_etc, etc, etc... --------------------- tbl_Consultants...

NOT MY CODE! Whoa! I could only WISH this was MY code... No, thank you but no... I actually do not know whose code this is (sadly)... As for the report thing, I agree... that is a pain... I tried working on other options to view but gave up... Never thought to export them to word... how...

Ok... I have a Table that has a thousand or so entries. The purpose of this table is to list out City Owned properties and give basic data on them... (Address, Roofing Structures, etc..) I built the table to fill-in until they were ready to hire out and have one professionally built. As I am...

Hide the DB Window If you create a module in Access and dump this code in it... Option Compare Database Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long...

Thanks Wayne... See... I can't remember where I heard that... but I know I heard it from someone who was an IT person... altho, from what I have gathered, the IT title doesn't necessarily mean knowledge... Well thanks...

Running an Access 97 database. It has 1000+ records. Maybe 20+ fields in a single table. Had an error. 'Operation invalid without a current index" Updated the Jet engine to 3.5 per MS recommendations. Still having problem. Database corrupted. My questions are: 1) I have heard that Access...

LIKE Ain't working... I already tried LIKE... I get the following error message... Compile error: Expected: = or <> or >< or >= or <= or =< [OK] [HELP] It just aint working... Oh, and I see an error that I should correct... The actual Select Case Statement is: Select Case StreetType...

Here is my code... Select Case StreetType Case "*Arterial*" StrType = "Arterial" Case "*Parkway*" StrType = "Parkway" Case "*Expressway*" StrType = "*Expressway*" End Select When I run the code, for an example, the value of...

I have a field that stores Alphanumeric characters. It has a limit of 18 characters. I want to run an Update Query. I want the Query to insert a space into the 5th spot. In other words: The current listing looks like: FIELD ES-98-00 ES-87-14-A ES-83-45 ES-78-13 (just a random assortment) I...

I need to know about this limit... I have heard that Access 'can't handle' more than a thousand records in a table. But then I have run them with over a couple thousand with no problems... Can someone clear this up for me? I would really appreciate it! Thanks in advance...

Ah... Sorry then... Thanks for the help...

No Answer? Did I ask a stupid question? A dumb question? Or was I not clear in my asking? Help me please! ack!

Not sure where to start... I have records that need to be handled / coded specially... In other words... Let's call this my OrderDatabase. Let's say I have a form, we will call it: OrderForm When I am filling in the order for a customer, if I pull up customer ABC, I want code to run in the...

Question for Pat Ok, so will the: DoCmd.RunCommand acCmdSaveRecord bring an error IF The record is old and has no changes? The record is new?

rst.edit - misunderstood I guess See, I am mainly self-taught here... And from what I understood of the Edit Method was that it would copy the currently edited record to the copy buffer so that you could then update it... I forget what happened but when I had just the Update Method running...

Save if Dirty YES! Ok, but will the: Docmd.RunCommand acCMDSaveRecord or the: If Me.Dirty = True then Me.Dirty = False Save it despite the record status? If it is an old record, and edited, I get glitches sometimes... Or if it is NOT edited, I get glitches... I just want to make sure it...

Error Description: Update or CancelUpdate without AddNew or Edit. Error Number: 3020 Source: DAO.Recordset I have update buttons that run like this one: ***************************************** Private Sub btnPrintSlip_Click() Dim rst As Recordset On Error GoTo ErrPrintSlip Set rst =...

I came upon an idea, and wonder about it's feasability (sp?). If I create a table...(let's say: tblEmployee) I create a field in that table...(lets say: emPosition) And I set that field's data-type to Lookup... And I enter in 20 different entries as a Value List... What if I want the users to...

Eh?! I am not sure I understand your question... Let me try to rephrase in words I do understand...then you tell me if I am wrong or right... You want to be able to have two tables... Table:Alpha holds scientists Studies Table:Bravo holds Publications You want to be able to link Studies to...

If a query is being run that retrieves values such as 68.98, what would I do to convert that to a format like: +000000000006898000 I need the format to contain 19 characters, the first one being a '+' and the last 5 characters should be the decimal place. Does anyone know how to achieve this...