Search results

What relationship do these two tables have to each other?

I got errors when I made the most significant change. The example on the websited used Lib "user" instead of Lib "user" Alias "SystemParametersInfoA". I got debug errors because it couldn't find the user library and then the SystemParameters entry point when I changed it. I changed it back...

I am just trying to change the wallpaper through code. The intent is to create a database that will randomly display different wallpapers. I know there are plenty of utilities freely available online that do this, but it is always more fun when you do something yourself. I believe I found...

A trick when you are first learning how to write SQL statements is to design a query that does what you want using Access' built in designer and then peek at the SQL (this is one of the views available to you when you have the query open). To open your recordset, you would use this line...

There is another alternative that will allow you to edit a querydef without deleting it. Sub ChangeRecordset(strSQL As String) Dim qdf As DAO.QueryDef Set qdf = CurrentDb.QueryDefs("qryInventory") qdf.SQL = strSQL qdf.Close 'I am not sure if this is necessary or not...

You would have to test for the duplicate before trying to add the record to do this. You could change it so that when you open your recordset, you put a WHERE clause that looks for the disp_DocNum. If it returns one, highlight the cells and move on. If it does not find any matches, add the...

This sounds like it may be something I have encountered before. If you copy and paste code into a form module, it does not appear to always draw the proper connection with the event that is supposed to activate it. If you look at the event properties of your control (cmdOK for instance)...

Thank you. Your code for the bold formatting was exactly what I needed. I saw that access did this in several places, and I had a hard time believing that it couldn't be duplicated.

I might be looking at this wrong or misunderstanding your question, because the answer seems to simple. But it appears the problem is that you have your variable inside your string. It should read: RetVal = Shell("C:\Program Files\Seagull\BarTender 6.20\Professional\bartend.exe...

I had installed PDF995 once and gave it a test run. Doesn't it have a sponsor page that pulls up unless you pay for a license? I didn't try operating it via code, but I would assume the same applies.

Search for CutePDF on google. It is a free application that can be used for this purpose.

It is going to update 0 fields because you already put values in all the fields that met the previous criteria. So none of those fields are Null. If you added the piece about empty strings, none of them are empty either. My guess is the one field that did not update has something stored in...

No problem. If it missed one field, you might have an empty string saved in fldFY05. Access distinguishes between fields that are Null (have nothing in them) and fields that are empty, basically meaning they have stored "". You might try adapting the parameters slightly "WHERE ([FY2005] Is...

If I am understanding you, it sounds to me like you want an update query. I am going to assume that you only want to update fldFY05 when it is Null (does not already have a value in it): UPDATE tblTableName SET fldFY05 = [fldAmtPd] WHERE fldFY05 Is Null AND fldDatePaid Between #7/1/2004# And...

The better solution is probably the answers that you were getting previously. I know there are many of them floating around this forum. It is a bit more involved, but it is best because you have greater control over the e-mail itself...

This is not my preferred way to handle e-mail, but if you are looking for one line of code.... docmd.SendObject ,,,"xxx@xxx.com",,,"Subject","The Order# " & Me!OrderNumber & " has just been placed. Please review and fill."

Thank you.

Someone might have asked this question before, but I couldn't get the right combination of words to make it come up when searching the forum. Is there anyway to make my Access application run in one window on the taskbar like Access 97? My user's have the perception of multiple apps running...

Can you clarify what you are trying to do?

I could have sworn I made sure the database was compiled before I tried creating the mde, but I just tried again and it worked. I thought I read somewhere that once you had over x number of modules, you couldn't create and mde but I can't find it again. Anyway, I now have an mde file. I'll...