Search results

Here is a code that may do it. Dim rsOrders as recordset set rsOrders = currentDB.openrecordset("tblOrders") with rsOrders .MoveFirst do untill .EOF !ClientDetailsID = varID !ClientDelete = varDel !ClientWant = varWnt if varID = varDel then .Edit !ClientDetailsID = varWnt .Update end if...

Dear Shutzy, From your code I do understand that you want to make [CleintDetailsID] = [ClientWants] if [ClientDetailsID] = [ClientDelete] in the tblOrders Table. Am I correct?

Thank you very much Michael and Spikepl. I created the form and code and macro and all is working fine.

Hi Alexlds, Normally you don't input data directly to a table. You do that through a user form. You should create a form to input data to your table,then create a textbox control to input firstname. create an afterupdate proceedure for the control to check if the entered name is 'John' then make...

Thanks Michael and Spikepl. As we are using an open wifi to connect, I just created a function that uses the Dir command. so I just Dir the BE file, If it returns a zero string then no network so open standalone file, else do nothing. My next task is to create an Autoexec macro to do just that...

Thank you Michael. I have used the ping command alot at the dos command prompt, but how can I script it? I have not done so before. On the other hand is there a VBA command or function to find the hostname?

Hi, My DB is split into BE and FE into about 5 Laptops. The DB is for entering personal information of pensioners. sometimes it becomes necessary to take a computer away from the office to capture data of sick and aged pensioners. Now if you take the server (BE) out all the other clients (FE)...

Hi, I want to view webcam image on a form with a command button to save the still pic as a bmp file. Can anybody help?

Hi Everyone, As we all know Access do not display numbers in accounting format (NGN1,234.78) in a message box. I developed thes functions to do just that. The functions are Putcommas and IntCommas. The Listings are as follows: Function PutCommas(Amt As String) Dim DotPos As Long, StrLen As...

Hello Martin, What you need to do is to remove that relationship first. Then create an EmployeeID field in the emplyee medicals table. The new field should be of the same datatype with Employee No field of the Employee details table. Now you can have your one-to-many relationship between...

Hi, I looked at your Db and your code. There are some basic mistakes. On the onclick event of the cmdSave button, you must first declare the variable AttendanceDate as date, then assign value of the current date to it. eg dim AttendanceDate as date . . AttendanceDate = date Likewise your...

Hi, Create a bcommand button on your Spare_Parts_Operations form, and add the following code. Dim Rst as Recordset, mySQL as string . . mySQL = "SELECT SpareParts.* FROM SpareParts WHERE (((SpareParts.ITEM)= " mySQL = mySQL & "name of the item to add" & " ));" set Rst =...

Hi, I've set the report's popup property to false, and the ribbon works properly. Thanks Avelino and vbaInet for your responses. I'm really grateful.

Hi, Yes the report opens popup and print preview mode. I selected popup because my application has a main form that remains opened through out. All other objects must open on top of the main form. Thanks.

Hello; I want to display a custom ribbon when I open a report in print preview mode. The ribbon name is PrintRibbon with the following xml: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="printMenu" label="PRINT" >...

Thanks LightWave. The link is of great help.

I am using 2007 version. How can I get the email content to a memo field?

Thanks LightWave. My issue is how to parse the information. Can you help?

Hi Rookie, The emails are I receive are automated replies, so they follow a particular patten. If I can extact it as a string, I can use it to update my records.

Hi All, I have a DB for monitoring housing loans. Customers make monthly repayments to my bankers, who sends me an instant email notifying me of the payment. Is there a way I can extract the contents of such mail automatically, so that I can update the my table? I read much about the email...