Search results

I built a ms database and I'm just wondeirng about the compatability of using 2007, what kind of issues can i expect to run into and does this sound like there will be a major overhaul needed in the programing, or should it be pretty straight forward.

I am trying to create a chart that displays employee efficiency per month. I want to to be available on the employees record. So I created a query that retrieves the date, employee ID, rating and that works fine. but when I make the chart and I choose the efficiency query I get an error...

Thanks for all you input, I always seem to make thing harder than they need to be, the filter did the job, while I am new to this I had used it before and just forgot about it. I like the idea of the auto number and sequencial number i'm test that out because I have done quite abit with...

Is there a way, aside from using auto number, to find a records postion. I am using a list and want to be able to double click an entry and have it open a form and go to that record. However I can't use auto number because I allow for the deleting of records, and once deleted the auto number...

I am making a code that has a format like this A-##-##-##-## B-###-## C-## I'm not sure what I would use in vbscript to be able to extract the letter, because it is that letter that determines the input mask of my text box. Basically what I want is for a person to input their code and if they...

thanks pbaldy that worked for me. ya, when i started this project it was my first time doing this, and now I have it loaded with relationships and code refering to that table, I really don't want to go back through everything, guess thats my laziness. But now I know for the future. Thanks...

the table I'm referencing when using runsql code in vb, can it not have spaces? Cause I can't figure out what is wrong with my code other than perhaps it isn't able to find the table I am referencing. My Code: Dim SQL As String SQL = "UPDATE Work Order Content SET [WO Status] =" & "'" &...

I'm using a button a remove entries in a listbox using this code, _________________________________________________________________ Private Sub removeCompanyBtn_Click() For i = 0 To Me.customerQueryList.ListCount - 1 If (Me.customerQueryList.Selected(i)) Then...

not that anyones replied but I figured this out so don't bother replying if you were going to it appears I just didn't have my textbox doing a requery of the listbox incase anyone looks at this and wonders the coded I used it is as follows...

I also used AND and that wasn't working for me either

I have a list box that is updated by a query, here is my query: _________________________________________________________________ SELECT [Work Order Content].[WO ID], [Work Order Content].[Work Order Number], [Work Order Content].[WO Date Ordered], [Work Order Content].[WO Date Needed] FROM...

awesome thanks for you quick reply

I have a form that is updating records using docmd.runsql(update...) when it updates it brings up a warning that it is going to up date the records, is there a way to turn off these warnings and how can I do this.

I came across DoCmd.runsql which has worked great for me, the only thing issue now is every time it updates a record it gives me a warning, how if it is possible do i get rid of that warning?

thanks for your revision, but that puts it into a string, now what do I do to execute that, I 've tried to make it a recordsource, and setting as a control source of a text box both didn't work. I'm clueless on how to get this to actually get called.

added note, I've been trying to use SQL Update, with no luck and it seems like it should be quite simple. Is this not the right syntax to update a table? Update TimeCard Set [TimeCard.Regular Hours] = 0 WHERE [TimeCard.Employee] = Me.employeeTextBox And [Job Date] = Me.mondaytxt1 I get an...

I have a timecard form and payroll form, the timecard form simply takes all the job information in and the payroll calculates all the regular time and overtime for a payperiod. I'd like the payroll form to update the the timecard table's fields regular time and ot time. From what I gather...

I'm trying to build a login screen, that starts the user off with a default password, once they log in with that default password, a form opens that has them change thier user info, password, a question and subsequent answer if they foget their password. They way I've opened the user info form...

I am looking at doing the same thing and I thinking it could be done using If statements in vb and based on the check marks chosen I would create the sql string for the list's control source. I'm not saying this is the way to do it just the way I've looked at it and to be honest I personally...

thanks for the reply. I'll have to give that a shot.