Search results

thats it thank you jon

is there simple way (without changing the table structor to check to make sure a number only has been entered in a field? If a user enters 0 - 9 its ok but if they enter a 2' it will fault? thanks jon

I have code behind a cmdbutton simple me.txt1 = "1" which when the button is clicked the txt1 box should get a 1. I get this error Run Time error -2147352567 This Recordset is not updatable. I have checked the form properties and it is set to allow edits. What else could it be? jon

yes i found that link and I'm trying it now.

Ok so I have it figured out on how to detect and change the resolution that im clear on. But how can I detect what a user has their DPI set to? I'm thinking if I can detect that I can has it make hem change that to run the dbase but I can't figure out how to detect it? jon

I have a form that has a bitmap picture on it and I have some hidden buttons that point to different parts of the picture. If the user points to a section info for that part is displayed. All that works fine until the user decides to change his screen resolution and or even worse changes their...

I don't have any of those close buttons. If I open in print preview i do see the red close button on the ribbon but I would perfer not opening it in print preview.

Is it just me? I open a report using a macro in normal mode. How the heck do you close that report? jon

I have a people table in my database and there is a yes/no check box that is used to confirm weather or not the person has completed paperwork required for a certian time. So the table could have thousands of people and I would like to reset this Yes/No field to No on the click of a command...

So say my select case has 25 different cases and the code within each case is specific to that case. So I could build a module with the 25 different functions in it or I could just create 25 Private Sub like Proc1() ...code End Sub Proc2() ... code end sub etc etc etc to proc25() and...

I think I'm ok breaking it down into smaller procedures. Better and easier to handle. 1 question tho is it better to have the Select Case result Call a function or break down to Call a Sub ? Private Sub PROC1() .... do something End Sub or Function PROC1() ... do something End Function or...

awesome thank you

To start off my problem started with a Select Case that got to big and started causing a complier error "Procedure Too Large" So after doing some research I figured that I needed to break the Cases down into inidivial procedures. So I figured it would be easier to create seperate Functions for...

I cant use the sendkeys because the esc key is turned off on this tab form. Any other ideas?

I'm having some trouble with a before update event. I'm trying to prevent incomplete records so on the before update event I have this code. So I can catch the null in the step, I get the error msg, I can get the undo so step88 has no data but I cant move the focus to the field that needs data...

The folder on the desktop is a place that the database puts a datafile that gets emailed out at the end of their shift. So what happens in the flow of things. Many users will enter data all shift long and at the end of a shift a lead will send out a shift report. I have made it so that the shift...

I used to use this code to create modify the registry so that every user would just have to click on a simple bat file to run my dbase without getting the security warnings. I just need to add this dir to the trust center "C:\USERS\PUBLIC\DESKTOP\WETCLEANS\" I don't want users to have to...

so let the query do the calculation and either display it on a chart or on a form. got it

I have to because I need the data put into a table so that I can build a chart from that data. I can't get the charts working if just the form displays the data.

wow I spent all day working on this issue and just figured it out. I knew it was going to be something stupid I just could not figure it out. On 1 of my 3 tables I did not have a primary key setup. Once I added the PK all was good. Crazy all day and most of the night.