Search results for query: *

i am trying to update textbox2 with the last record entered into textbox1, having just saved the record to a table! In Access this was fairly easy: Control Source = Last("textbox1") Is there an easy way to do this in VB.net??

Does anyone have any quick code which will set combobox list items (3 items) to different colors. I want to set the following: index 0 = white, index 1 = yellow and index 2 = pink. I'm sure this is fairly simple just can't suss it out....

I am having problems writing some user login DataReader code. I'm not entirely sure how the DataReader object works and have come a cropper when trying to authenticate the txtPassword data. Do I need to initialise 2 select queries (1) username (initials)(2) password (Login_ID), can i use a...

how do i limit entry into a textbox to either a 7 digit number or 6 digit alphanumeric string? I have tried the following code but no luck, is it a syntax error? can anyone help? If Not (txtFileName.Text = "[0-9],[0-9],[0-9],[0-9],[0-9],[0-9],[0-9]" Or txtFileName.Text =...

I am trying to recreate some DLookup code in .net.....but having some difficulties. All I want to do is lookup existing table data so as to validate against user textbox duplicates....if there is a duplicate record then provide an error message, followed by inserting the duplicate into an...

Private Sub txtF2Total_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles txtF2Total.Validating I wish to validate a textbox (txtF2Total) to accept just 3 possible values: "0", "2" and "9". This was simple in Access however i am struggling. Can anybody...

I am having trouble binding radio buttons(have also tried checklistbox's and checkbox's)to an Access table. All the textbox controls on my data input form work fine and insert the data to the table, however the radio button checks do not pass to the table. I have bound the data using the data...

I have 2 forms. In the first (logging)I bleep in 50 records and in the second (validation)I re-bleep the same 50 records into a textbox (Photoset_PID) to validate the logging input process. To avoid missing records out and also to speed up retrieval of these missed records I have placed in the...

I am currently getting Runtime Error 2001 "You cancelled Previous Operation, when trying to run below DLookup(). I have checked all table field speelings etc. [AbbotBoxNumber] is Text datatype and this I believe is where I am getting the problem as have tested the procedure with number datatypes...

I am trying to right a loop that tests whether a text box integer value and a command button event click are false before executing the body of the loop. Problem is that I can't get my head round the cast issue. See below code any assistance would be appreciated: Private Sub...

I have a validation form that a user will scan 175 records into a textbox using a barcode scanner. I am attempting to reduce the number of keystrokes a user has to press when updating this form, i.e. i dont want them to have to press enter after each record!! To do this i hope to be able to...

I am trying to pass a txt box value to a report so that I can dynamically print a report that displays the records that are equal to SQLtest in the below code. I presume I can use a standard report, and then pass field values so that only certain values from table are reported on. No luck yet...

I am trying to run this update query and keep getting the "Enter parameter value" input box when i try and add text data. The updating works fine with numeric data type but not with text type data. The database field is set to text type but still no luck. If I go to the query design window I can...

Trying to get the below INSERT INTO sql statement to run. Any ideas where I am going wrong? Private Sub CmdInsertAbbotBoxNumber_Click() Dim rs As DAO.Recordset ' requires DAO reference 'assumes number data type for PID Set rs = CurrentDb.OpenRecordset( _...

Hi this may be a stupid question but need some assistance. I am developing a form to validate 174 records. When all 174 records have been cross checked with logging table (table will conatin more than 174 records each record will be referenced to a particular batch number), I then need to insert...

Hi I'm a VB newbie and was wondering if someone might be able to help me with a looping problem. I am trying to adapt an if/ else statement to include a counting loop which if condition not met I want programme to update an errorlog table with txtbox data. here's the spec: - 'User inputs PID...

Is there a way of importing a number of text files (approx 100 files)comprising CSV data into 1 Access TABLE in one single go or command? thanks Simon

Hi, I am having a few problems writing code to display in a form the number of records updated to my table . I have tried to write code with counter incrementation, but hitting problems as my programming is very basic. Someone suggested adding an autonumber field to the data table that I am...

Hi, i am attempting to add a counter to an input form and display the current counter value as the user continues to update records. I have some basic code which seems to work BUT I would like to store the counter value in a table field so that if the form is closed and reopened the value...

Hi It's been a while since I worked with Access Basic. I am getting the 'compile error - method or data member not found' on the following line of code: rstSecurity.FindFirst "[Initials] = '" & Me![txtUserInitials] & " '" I cant seem to work it out, even though the code has worked perfectly...