Search results

Hmmm. I must be missing something. I simplified everything to the bare bones just to get it working first. This is what I have in the after update of the CustomerID field but I am still getting the message "You cant use find or replace now". Dim temp As Integer temp = Me.CustomerID Me.Undo...

Ok seems easy enough, but how do I go about "switching" to edit mode after the form has been opened in add mode? i can say about 95% of the time the user will be adding a record which is why I need to originally open the form in add mode.

Thanks. I already use the Dlookup function to determine if there is an existing record which is not too different form the dcount function you suggested. Once it is determined if there is an existing record I use the me.undo command. Is this the correct method to use? This essentially erases...

I am having trouble with a very simple task. I have a form that is opened in "add mode". The user enters the customers account number (same is the customer ID primary field) and I want it to lookup if the account number already exists in the underlying query and if so then navigate the form to...

Ah I think I found the culprit... At first I just skimmed through your linked article and it seemed like nothing I already found out myself. I knew it had something to do with the BIGINT data type, but I tried all of the workarounds with no success. Then i re-read your link and found one little...

Hello. I am trying to link a MySQL database to my Access file and am having some trouble. First off the MySQL database was created by my other, industry specific, software provider. They recently updated to the MySQL format so people like me could now access the data outside of that software...

Ok here's an update... This is what I have: 'HTTP variable Dim myHTTP As MSXML2.XMLHTTP 'HTTP object Set myHTTP = CreateObject("MSXML2.ServerXMLHTTP") 'create dom document variable, stores the xml to send Dim myDom As MSXML2.DOMDocument 'Create the DomDocument Object Set myDom =...

There is nothing wrong with creating the XML from scratch each time, the only problem was that I didn't know how to. I read over DJKarl's link and it got interesting, but then it ended just when they were getting to the good stuff. I need to read over it again and possibly find a follow up or...

Thanks for the response. i looked over your link and I am pretty good with understanding and learning new techniques but that was greek to me. I will have to read through it a few more times to understand it more. As for encrypting the CC data... Intuit does offer (and the only option BTW) HTTPS...

So my new project is to create a DB form that processes credit card payments. I already have a merchant account with Intuit. They have a SDK kit that allows you to create your own application and link credit card processing to your existing merchant account. In short, the process is to...

Yes in the underlying table I have 3 seperate fields [city] [state] and [zip], and combine them to "view" as 1 field. I want to edit that 1 field and have the 3 underlying fields updated correctly. How would I go about having the table "realize" the addresses as you suggested?

I have a field on my form that I need to combine my [city] [state] and [zip] fields into one field, BUT ALSO make that field editable. I already know how to simply combine those fields using =[city]&" "&[State]&", "&[Zip] in the control source, but although that displays everything in the...

Thanks the on timer worked

I need to create a splash screen to display on startup of my database. I already know the trick of placing a .bmp of certain size with the same name as your database in the same directory of your database and it will replace the Access splash screen, but I need to go one step further... I have...

Commented the code out and still wont open (well, when the Access window is small). To be honest, I have never used a crosstab query before, and not sure what they are or how to use them. I'm not saying I'm a pro at Access yet, but I have come a long way since I started and a little...

Sorry for the delay... Yes I do have code in the on load of the report that is displayed below. Like I stated before, this report is untraditional in design, and before I get an earfull about how its wrong to design/code it the way I did, let me explain why I did what I did a little first...

Well the title of this post is not exactly true, but only when certain circumstances are met. You see, my database is configured where the Access window itself is set to a pretty small size. I have 1 main navigational form that is roughly 1.5" tall by about 6" wide. I hide the navigation pane...

The SQL from the query that sums the total for day is: The name of this query is "Payroll Calc" SELECT Sum(EmployeeLog.Total_For_Day) AS SumOfTotal_For_Day, EmployeeLog.WorkWeekID, Employees.FName, EmployeeLog.EmployeeID, Workweek.StartingDate FROM (Employees INNER JOIN EmployeeLog ON...

i have an Employees table which holds amongst the basics, Hourly Rate, Daily Pay, and Weekly Salary, fields which are used based on the employee type. I also have a Employee Log table that holds, Work Date, Start/End Times, Hours (which is calculated after start/end times are entered), Total...

I have a form in continuous forms view and I need to rather view or hide certain controls based on other criteria, but only for those records and not all records. For a simple example (not an actual example, just ease of understanding one), lets say I have a form with a checkbox field and a...