Search results for query: *

Hi, I've look around and haven't found the answer I'm looking for. I'm trying to just open Google Maps in IE with a button in Access. I'm making some silly error that I can't seem to figure out. Just need a second set of eyes to maybe tell me what I'm doing wrong. Private Sub...

Hi, This is probably easier than I'm making this out to be. If I have a data table that is denormalized and I want to import the data into a normalized database what steps do I take? What I have is very simple I have a table with facility and contact information. I want to seperate the data...

I have the script running perfectly, but there is just one problem. In the event that someone enters a value with a comma in a cell it prints the csv file incorrectly. Here is the code: Public Sub WriteSheet(curSheet As Worksheet, pathstr As String, col As Long, row As Long) Dim txtStr As...

I guess it is not that complicated, but I have a report that I am filtering by date. I have it working fine. But I want to add the option to allow the user to select by which date they filter the report. Right now I have a filter form with txtStartDate and txtEndDate and in the query (I just...

Hi, I am trying to create a summary report. The fields I want to summarize are in a Yes/No format. I have a query behind the report that pulls all of the fields that are Yes. It is set up like this... SELECT tblEnforcement.[103], tblEnforcement.[103CR], tblEnforcement.[6RK], * FROM...

Can "Find and Replace" search values in invisible text boxes in forms? I did look at the FAQ's, if anyone knows what FAQ this is in please let me know! I am just trying to have the Find and Replace search through all text boxes on a form, even invisible text boxes. Thank you!

Hi, I have a textbox that I have hold the value for a case number. The textbox name is caseNum. I want it to be in this format "07KS2007" + caseNum for example 07KS2007123, where the case number is incremented up by 1 with every new case. I have a button that needs to be clicked to add the...

I will try to explain this the best I can. I am attempting to make a user interface for access using pages. This is new to me. So this is what I have done so far. I have 1 main form. On the main for I have the tabs set up with subforms in each of them. What I am trying to do is link all of...

Okay I don't know how to word this so it is not complicated. So I will give this my best shot, let me if it doesn't make any sense. I have 3 tables that are linked: tblFacility, tblEnforcement, and tblInspection. Each table uses the same value for a key. On the form I am working with, it is...

I have a problem, I am making a form to enter dates. If I don't put in validation rules eventually the bad dates get into the database and to avoid that I am trying to create an error message that a user will understand. I have the code working for the default inputmask violation, but in the...

Okay, this is probably a commonly asked question. I looked on the internet and through this forum and didn't find my answer. So I'm just going to ask. How do you get around a form autosaving data into the table it is bound to? Does anyone have a code sample to point me in the right direct...

I have created a database with Access. I don't know if this is a built in function or if I just need to change a property setting somewhere, but on all the forms when you enter data Access automatically starts saving the data, without having to use a save button. How do I remove this? Do I...

Do any of you know how to display a live moving clock on an Access form? I know how to do the time stamp, but I just thought it would be cool to add in the "live" clock. I was just looking for an example or help in the right direction. Thanks!