Search results

Someone else may be able to explain why this happens. I do know that this happens to me however if see the white box you can get out of design mode and then go back in. For some reason that seems to work. I'd be interested as well to see if there is a better way. Gregg

I found a post from yesterday that led me to the same solution RG. That is correct. Thank you so much for your help. And thank you Alc for your efforts. Have a safe holiday tomorrow. Gregg

Thanks Rural Guy I tried that and I got a error message "Run time error 3464 - Data type mismatch in criteria expression". I tried to do this DCount("[clientid]", "[tblMain]", "[clientid] =" & "'client'") >= 1 however i go back to having the same issue that there is no match. Very Curious

I have had that happen when multiple users try to share a database that has not been split into a frontend and a backend. Gregg

I am having a issue with a dcount not working properly. The table is called tblMain In this table is a field called clientid as text I am delcaring a field in my database called client as a string Here is the current code: ''''''''''''''''''''''''''''''''''''''''''''''' Dim client As...

The only suggestion I can think of is to run 2 jobs with the job scheduler. One can execute the script that will run the delete query and then set the database to compact on close. Then run another job schedule to activate another vbscript that activates another macro that will run the new...

I'm not sure about a macro but you can set the database to compact when its closed. Options General check "compact on close"

You can also use the shedule task in Programs/Accessories/System Tools/Schedule Tasks to activate your VBscript. Try this with VBscript. ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' 'Read from a Microsoft ACCESS database Option Explicit...

I'm not sure if this is the same situation, but when I first started with my department the users were sharing a database without it being split. In these cases it would create a file similar to what you are talking about. I'm pretty sure it was db1, then db2 sometimes. I tried to recreate it...

I think you can you use the replace function: Replace([FieldName], vbCrLf, "") Gregg

Adam, Thats a great solution , thank you so much. I was not familiar with the isnumeric sytax or that you could use a iif statement within a function like that. I love this forum. Thanks again. Gregg

Thanks for the assistance. Here is what I have got from your suggestion: ID is the field that the web address is in. I am using "document_id" to id the character location and adding 12 to get my start position. =Mid([ID],InStr([ID],"document_id=")+12,6) This does work, but I am not sure if...

I need some assistance parsing some information from a web address. Here is an example of what the web address is. -http://www.websitename.com/ct20/pages2/client_bcphone_service_order.aspx?client_id=1603994&contract_document_id=924182&cipid=206123444- What I am trying to do is get the client ID...

I'm not very familiar with Macs myself however I know you can dual boot with Windows if you want to. This way you can put Access on the windows side of the PC. I don't think they make access in the Mac office version. gregg

I have a feeling my problem is different then yours. Good luck finding an answer.

I think I may have found the answer in another post. It looks like it is an update from adobe that needs to be done. Here is the post in case anyone comes across a similar problem. http://www.access-programmers.co.uk/forums/showthread.php?t=81142&highlight=link+pdf

Ghudsons browse directory database I may be having a similar problem. I am using Ghudsons browse directory database. http://www.access-programmers.co.uk/forums/showthread.php?p=440522#post440522 . The form fFindOpenImportFile method works fine when importing and opening a pdf file. The form...

Thanks Dan. I actually just found a solution just like that. Thank you for taking the time to look for a solution. I do appreciate it. Here is what I found that I am using. Excuse me for not remembering where or who it came from. Public Function RoundUP(RoundMe As Double) Dim RoundAnswer As...

I am having a small problem when using the Sum function on the footer of my form. I am using the following: =Sum([UnitQty]*[UnitCost]) UnitCost is a currency and UnitQty is a number This is working except for one senario. Sometimes the quantity is a decimal. For instance, 27.75 X 0.5 =...

This website has some good information about the Dlookup function. http://www.mvps.org/access/general/gen0018.htm