Search results

thanks, but nope .. that didn't work either. This is mind boggling! Do you know of a way to do it in VBA? Maybe there's a way to tell Access what workgroup to use through VBA. I also tried using the command-line arguments on the Advanced tab under options in Access.

Is there anyone out there that can help me with this problem. I want to create a hyperlink in MS Outlook to my database file using my workgroup. The problem I'm having is when I put the following: file://"N:\DbaseFiles\SCC_Dbase.mdb" that works. It will open Access to that dbase file. But...

I have a locking file that I can't seem to remove. No one is in the database that's associated with the file but it tells me there's been a sharing violation. Can anyone tell me how to remove those files?

Thanks so much for all your help. The function worked. I think I understand now how the variable is being passed the value.

I don't quite understand how you are passing the field's value to tmpStr. I understand the For Next statement and the IsNumeric statement. But how are you getting the data passed to the variable?

thanks for all your help. I'm usually a quick learner but this one has me stumped. I've attached the database. Thanks again.

It didn' t work for me. The field is in a table of 6000 records where the phone number is keyed in so many different ways. Ex:999/999-9999 or 999.999.9999 or 9999999 . I just need to get it to display nothing but the numeric characters. I was hoping there was an easier function to run that...

wow! that seems a bit complicated however, I'm going to try it. Will that code cycle thru all the records and where will the new value be?

I'm sorry but could you be a little more specific? What text manipulation functions are you referring to? Is there a "numeric only" function? I know of the InStr, Left,Mid, and Right functions but those aren't going to get the job done.

Is there anyway to strip all characters except numeric out of a value? For example: 999/777-5555. I want to strip the / and the hyphen. The characters can vary so is there anyway to recognize just numeric?

it didn't work sir.

does this code go on the onClick event of each checkbox?

Never mind. I think I just figured it out. This is what I did differently with that expression: =DCount("[ID]","tblWeeklyNumbers"," [data_store] = 'INS' and [created] <= Forms!frmDateRange_forWeeklyStatRpt![txtend] And ([status] = 'active' or [status] like '*Pending*' or [status] = 'open' or...

I want to count the total of [IDs] in a table called "myTable" where the [created_date] is equal to 10/5/07 and where the [data_store] is equal to "INS" and where the [status] is equal to "active" or "open" or "accepted" or "activated" or like "pending". My expression doesn't return the correct...

thanks guys. I fixed it. The error was on me. I was mispelling the field. My first syntax worked. =dcount("id","tblPercentages","[recvddate] = [completeddate]") I apologize for the inconvenience of even entertaining such an amatuer situation.:o

Not quite. Basically, if checkbox rvd_credit and checkbox rvd_motorVR and checkbox rvd_SSN are supposed to be checked those checkboxes would be enabled. As each document has been reviewed the end user will check the appropriate box. The [date completed] field should not become enabled until...

I hope I can explain this correctly: I have 6 check boxes on (FormA). On(FormB) I have 6 check boxes that initially are disabled. Depending on what the user checks on (FormA) will enable the corresponding check boxes on(formB). The end user will check the enabled boxes on (FormB) as they...

thank you but that didn't work either. this is really puzzling me. I never had to use criteria where 1 field's value is equal to another field's value. I 've always used criteria where 1 field's value is equal to a value on a form or on a report.

I have a control on a report that has a user defined function as the controlsource. Basically I want to count the number of records where the recvdate is equal to the completeddate in the table. For example: [recvddate] = 9/18/07 and [completeddate] = 9/18/07 this record would get counted...

Yes. Exodus, this is what I have. I have a backend where my tables live and that file is in a seperate location. My frontend links up to the backend. That isn't my issue. I want to simply keep them from accessing the database file from the directory. And if they try to open it from the...