Search results

@ Lightwave My google maps are a bit more complicated than that, but fortunately, I just checked my database this morning and now everything works. I am guessing Google resolved whatever the issues were, but thankyou for responding.

Is anyone having issues with Google Maps in a webBrowser Control? All of my features using Google Maps within a webBrowser control have stopped working and the day they stopped occured when Google put out a new api version. Here is a post I put on stack exchange with more details...

It is not clear what you are talking about (at least to me) and I am not sure what your question was..you may want to rephrase a bit

alright here you go, I wasn't sure what you wanted with the save button...when you enter data into a field within the form it is automatically entered into the table, but i threw in a save button just in case. The compile issue you had earlier was because you had attempted to write some code but...

Im guessing this is your function: function GetUserName() GetUserName = Environ("UserName") end function Environ will return the username that you use to log into windows with. If you want to post your database, I will set it up for you. I would only need the list of users you dont want clicking...

If all you want to do is lock a checkbox based on the user then place an unbound text box in the form by the checkbox (call the text box 'User'), you can hide it by setting it invisible. Place this in its source: = Environ("USERNAME") Then under form events --> on open --> type If Me.User =...

you can attach the database by clicking 'Go Advanced' in stead of 'Post Quick Reply' a simply gutted version with only the tables is fine. So you could import the tables to a new database and attach that. Though if i remember correctly, you may need 5 or 10 posts in the forums before you can...

i would need to see your database in order to design a query to do what you want, but from your posted sql, i would suggest using 'Group By' Min and Max instead of First() and Last() because those functions retrieve the first and last record but not necessarily the first and late date. If you...

without seeing any of your table structure im going to guess, but one prob is that youll have to identify which records youll want to compare if you just want to view the total days overlapped. So if your interested in viewing which work orders overlap a particular work order, you can set up a...

Perfect! didnt realize it was this simple, thanks so much!

Does anyone know some useful sites for understanding vba interactions with web page features? Id like to be able to open a web page and target an input box within the page and populate it with an address. For example, I am using a web site which helps determine zip codes for an address. When I...

I was having a problem where individuals were constantly asking for unique results and odd calculations that were very simple using a query but were one time deals. my solution was to create a form that acted as a query. They can select the table which then allows the selection of fields and...

Your SQL would help, but if you want to exclude anything ending in "com" then: Place this in your criteria.....Not Like "*com"

if you select multiple rows in the table design and click the primary key button, it will assign the key to more than one field. The customerID field should be in the customer table. In order to link the two tables by customer, you would use a form allowing the selection of that customer ie...

Try this. =("*"&"[AllQueryNoNS.Element]"&"-"&"[AllQueryNoNS.Mark]"&"-"&"[AllQueryNoNS.Weld]"&"Nz([AllQueryNoNS.RorRR])"&"/T/"&"[AllQueryNoNS.Root]+"*") /fingers crossed

umm, I am not sure what your asking here...You mention a basic database and a main database, as well as a table used as a spreadsheet implying the use of excel and not access? Do you have one or two database you are linking? Are you using excel, if not what is the external source of your data...

firstly, you do not need to combine the first and last name in one field, and it is not recommended. if you need to combine them for search reasons or reports, use a query. Without seeing your tables or any structure I can't offer much more advice.

Alright, this is possible because I have had to do this many times. you need to construct the access table in excel first, ie the excel columns data must reflect the same order as the access field columns. for the autonumber in excel simply generate an autonumbering for that column, ie =B1 +1...

umm k, well your sample database does not include the macro you are having trouble with nor does it include the form in which it references ie RecordSource. It is unclear to me which form this macro was placed in, how it is selected, why you are using it, etc

This may guide you in the right direction. http://support.microsoft.com/kb/290136